For SQL Server 6.5 information, see sysprocesses System Table in What's New for SQL Server 6.5.
Contains information about SQL Server processes. The sysprocesses system table is not a standard table. Rather, it is built dynamically when queried by a user. Updates to sysprocesses are not allowed. Use the KILL statement to cancel a process.
| Column | Datatype | Description |
|---|---|---|
| spid | smallint | Process ID |
| kpid | smallint | Windows NT thread ID |
| status | char(10) | Process ID status (for example, runnable, sleeping, and so on) |
| suid | smallint | Server user ID of user who executed command |
| hostname | char(10) | Name of workstation |
| program_name | char(16) | Name of application program |
| hostprocess | char(8) | Workstation process ID number |
| cmd | char(16) | Command currently being executed |
| cpu | int | Cumulative CPU time for process |
| physical_io | int | Cumulative disk reads and writes for process |
| memusage | int | Number of 2K pages of the procedure cache that are currently allocated to the process |
| blocked | smallint | Process ID of blocking process, if any |
| waittype | binary | Reserved |
| dbid | smallint | Database ID |
| uid | smallint | ID of user who executed command |
| gid | smallint | Group ID of user who executed command |
This table does not have any indexes.
| sp_dboption | sp_who |