| ACTFLAG |
|
INT4 |
10 |
0 |
|
|
|
| FIRSTOCCUR |
|
CHAR |
23 |
0 |
|
|
|
| REQSPID |
MS SQL Server process ID |
INT2 |
5 |
0 |
|
MSSREQSPID
|
|
| HOLDSPID |
MS SQL Server process ID (blocking) |
INT2 |
5 |
0 |
|
MSSBLKSPID
|
|
| REQPID |
MS SQL-Server host process id (= OS work process ID) |
CHAR |
8 |
0 |
|
MSSHOSTPID
|
|
| OPEN_TRAN |
Number of open transactions for the SQL Server process |
INT4 |
10 |
0 |
|
MSSOPENTRAN
|
|
| PROCSTAT |
MS SQL-Server process status |
CHAR |
10 |
0 |
|
MSSSTATUS
|
|
| USERNAME |
MS SQL Server user name |
CHAR |
30 |
0 |
|
MSSUNAME
|
|
| HOSTNAME |
Hostname of the application server logged into SQL Server |
CHAR |
30 |
0 |
|
MSSHOSTNM_
|
|
| PROGNAME |
Name of the application program which owns the connection |
CHAR |
30 |
0 |
|
MSSPRGNAME
|
|
| COMMAND |
MS SQL Server command |
CHAR |
16 |
0 |
|
MSSCOMMAND
|
|
| INPUTBUFF |
Output from DBCC INPUTBUFFER for lock display |
CHAR |
40 |
0 |
|
MSSINPUTBUFF
|
|
| WAITTIME |
Current wait time of the process in milliseconds |
INT4 |
10 |
0 |
|
MSSWAITTIME
|
|
| WAITRSC |
Wait Resource as seen in sysprocesses |
CHAR |
40 |
0 |
|
MSSWAITRSC
|
|
| LASTWTYPE |
Last Wait Type as seen in sysprocesses |
CHAR |
32 |
0 |
|
MSSLASTWTYPE
|
|
| DBNAME |
MS SQL Server: Database name |
CHAR |
30 |
0 |
|
MSSLDBNAME
|
|
| OBJNAME |
Table name |
CHAR |
30 |
0 |
*
|
MSSTNAME
|
|
| INDEXNAME |
MS SQL Server object name |
CHAR |
30 |
0 |
|
MSSOBJNAME
|
|
| LOCKRSC |
Textual description of a lock resource from syslockinfo |
CHAR |
32 |
0 |
|
MSSLOCKRSC
|
|
| LOCKTYPE |
Char representation of rsc_type from syslockinfo |
CHAR |
10 |
0 |
|
MSSCHARLOCKTYP
|
|
| LOCKNAME |
MS SQL Server lock description text |
CHAR |
35 |
0 |
|
MSSLOCKTXT
|
|
| LOCKSTAT |
req_mod from syslockinfo for blocking/blocked lock entry |
CHAR |
10 |
0 |
|
MSSLOCKMODE
|
|
| REQ_REFCNT |
req_refcnt from syslockinfo for blocking/blocked lock entry |
INT4 |
10 |
0 |
|
MSSREQREFCNT
|
|
| REQ_OWNERTYPE |
req_refcnt from syslockinfo for blocking/blocked lock entry |
CHAR |
12 |
0 |
|
MSSREQOWNTYP
|
|