A summary of the results returned by sp_ps as rows with columns.
Column Name |
Datatype |
Length |
---|---|---|
SPID |
CS_INT_TYPE |
4 |
Login Name |
CS_CHAR_TYPE |
SRV_MAXNAME |
Host Name |
CS_CHAR_TYPE |
SRV_MAXNAME |
Program Name |
CS_CHAR_TYPE |
SRV_MAXNAME |
Task Type |
CS_CHAR_TYPE |
SRV_MAXNAME |
Status |
CS_CHAR_TYPE |
SRV_MAXNAME |
Sleep Event |
CS_INT_TYPE |
4 |
Sleep Label |
CS_CHAR_TYPE |
SRV_MAXNAME |
Current Command |
CS_CHAR_TYPE |
SRV_MAXNAME |
Blocked By |
CS_INT_TYPE |
4 |
Run Ticks |
CS_INT_TYPE |
4 |
Current Priority |
CS_INT_TYPE |
4 |
Stack Origin |
CS_INT_TYPE |
4 |
Net Writes |
CS_INT_TYPE |
4 |
Net Reads |
CS_INT_TYPE |
4 |