| SPID |
MS SQL Server process ID |
INT2 |
5 |
0 |
|
MSQSYPROID
|
|
| KPID |
Windows operating system thread ID |
INT2 |
5 |
0 |
|
MSQTHREDID
|
|
| BLOCKED |
SPID of blocking process. |
INT2 |
5 |
0 |
|
MSQBLOPRID
|
|
| WAITTYPE |
Wait type of waiting process, reserved field of sysprocesses |
INT2 |
5 |
0 |
|
MSQWAITTYP
|
|
| DBID |
MS SQL Server database ID |
INT2 |
5 |
0 |
|
MSQDBASEID
|
|
| USERID |
MS SQL Server - user identification ID |
INT2 |
5 |
0 |
|
MSQUID
|
|
| CPUTIME |
MS SQL Server total cumulative CPU time for a SQL process |
INT4 |
10 |
0 |
|
MSQCPUTIME
|
|
| PHYIO |
The total cumulative disk reads and writes for the process. |
DEC |
20 |
0 |
|
MSQPHYSIIO
|
|
| MEMUSUAGE |
The pages allocated by the SQL process in procedure cache. |
INT4 |
10 |
0 |
|
MSQPRMEMUS
|
|
| LOGINTIME |
Login Time for client process or system startup time |
CHAR |
24 |
0 |
|
MSQLOGTIME
|
|
| LSTBATTIME |
Last time exec. of remote stored proc. call or sql stat. |
CHAR |
24 |
0 |
|
MSQLSTEXST
|
|
| PROSTATUS |
SQL Server process status; ie sleeping, running etc. |
CHAR |
60 |
0 |
|
MSQPROSTAT
|
|
| SIDNAME |
The user name used to log into the SQL Server database |
CHAR |
128 |
0 |
|
MSQUSRNAME
|
|
| HOSTNAME |
Hostname of the application server logged into SQL Server. |
CHAR |
256 |
0 |
|
MSQHOSTNAM
|
|
| PRONAME |
Name of the application program which owns the connection. |
CHAR |
256 |
0 |
|
MSQAPPPROG
|
|
| HOSTPRO |
The application program's process ID on the given host |
CHAR |
16 |
0 |
|
MSQWKPROID
|
|
| CMD |
Command currently being executed by the given process id |
CHAR |
32 |
0 |
|
MSQEXECMD
|
|
| NTDOMAIN |
NT domain for the client connected to SQL Server. |
CHAR |
256 |
0 |
|
MSQNTDOMA
|
|
| NTUNAME |
Windows NT user name for the process connected to SQL Server |
CHAR |
256 |
0 |
|
MSQNTUNAME
|
|
| NETADD |
Unique ID of the network interface of client (MAC address). |
CHAR |
12 |
0 |
|
MSQNETADDR
|
|
| NETLIB |
The network library the client is using. |
CHAR |
12 |
0 |
|
MSQNETLIB
|
|
| SUIDNAME |
The user name used to log into the SQL Server database |
CHAR |
128 |
0 |
|
MSQUSRNAME
|
|