sysprocesses
The sysprocesses table holds information about processes running on Microsoft® SQL Server™. These processes can be client processes or system processes. sysprocesses is stored only in the master database.
| Column name | Data type | Description |
|---|---|---|
| spid | smallint | SQL Server process ID. |
| kpid | smallint | Microsoft Windows NT 4.0® thread ID. |
| blocked | smallint | Process ID (spid) of a blocking process. |
| waittype | binary(2) | Reserved. |
| waittime | int | Current wait time in milliseconds. Is 0 when the process is not waiting. |
| lastwaittype | nchar(32) | A string indicating the name of the last or current wait type. |
| waitresource | nchar(32) | Textual representation of a lock resource. |
| dbid | smallint | ID of the database currently being used by the process. |
| uid | smallint | ID of the user who executed the command. |
| cpu | int | Cumulative CPU time for the process. The entry is updated for all processes, regardless of whether the SET STATISTICS TIME ON option is ON or OFF. |
| physical_io | int | Cumulative disk reads and writes for the process. |
| memusage | int | Number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process. |
| login_time | datetime | Time at which a client process logged into the server. For system processes, the time at which SQL Server startup occurred is stored. |
| last_batch | datetime | Last time a client process executed a remote stored procedure call or an EXECUTE statement. For system processes, the time at which SQL Server startup occurred is stored. |
| ecid | smallint | Execution context ID used to uniquely identify the subthreads operating on behalf of a single process. |
| open_tran | smallint | Number of open transactions for the process. |
| status | nchar(30) | Process ID status (for example, running, sleeping, and so on). |
| sid | binary(85) | Globally unique identifier (GUID) for the user. |
| hostname | nchar(128) | Name of the workstation. |
| program_name | nchar(128) | Name of the application program. |
| hostprocess | nchar(8) | Workstation process ID number. |
| cmd | nchar(16) | Command currently being executed. |
| nt_domain | nchar(128) | Windows NT 4.0 domain for the client (if using Windows Authentication) or a trusted connection. |
| nt_username | nchar(128) | Windows NT 4.0 user name for the process (if using Windows Authentication) or a trusted connection. |
| net_address | nchar(12) | Assigned unique identifier for the network interface card on each user's workstation. When the user logs in, this identifier is inserted in the net_address column. |
| net_library | nchar(12) | Column in which the client's network library is stored. Every client process comes in on a network connection. Network connections have a network library associated with them that allows them to make the connection. For more information, see Client and Server Net-Libraries. |
| loginame | nchar(128) | Login name. |