The sysprocesses table holds information about the processes running on Microsoft®sql Server™. These processes can be either client processes or system processes. sysprocesses are only stored 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 the process ID (spid) of the chunked process.
waittype binary (2) reserved.
waittime int The current wait time, in milliseconds. When the process is not waiting, it is 0.
Lastwaittype NCHAR (32) represents the string of the last or current wait type name.
Waitresource nchar (32) A textual representation of the lock resource.
dbid smallint The database ID currently being used by the process.
UID smallint the user ID of the execution command.
The cumulative CPU time of the CPU int process. This entry is updated for all processes, regardless of whether the SET STATISTICS time on option is on or OFF.
Physical_io the cumulative disk reads and writes of the int process.
Memusage int the number of pages in the process cache currently assigned to the process. A negative number that indicates that the process is releasing memory allocated by another process.
Login_time datetime When the client process logs on to the server. For system processes, the time at which SQL Server startup occurs is stored.
Last_batch the time that the datetime client process last executed a remote stored procedure call or EXECUTE statement. For system processes, the time at which SQL Server startup occurs is stored.
Ecid smallint is used to uniquely identify the execution context ID of a child thread acting on behalf of a single process.
Open_tran the number of open transactions for the smallint process.
Status nchar (30) Process ID state (such as run, hibernate, etc.).
Sid Binary (85) the user's globally unique identifier (GUID).
Hostname NCHAR (128) The name of the workstation.
Program_name NCHAR (128) The name of the application.
Hostprocess NCHAR (8) Workstation process ID number.
CMD nchar (16) The command that is currently executing.
Nt_domain NCHAR (128) a client's Windows NT 4.0 domain (if Windows authentication is used) or a trusted connection to a Windows NT 4.0 domain.
Nt_username NCHAR (128) The Windows NT 4.0 user name for the process (if Windows authentication is used) or the Windows NT 4.0 user name that is trusted for the connection.
Net_address NCHAR (12) assigns a unique identifier to the network interface card on each user workstation. When the user logs on, the identifier is inserted into the net_address column.
Net_Library NCHAR (12) is used to store the columns of the Client network library. Each client process is entered on a network connection. Network connections have a network library associated with these processes that enable these processes to establish connections. For more information, see Client and server Net-library.
Loginame NCHAR (128) login name.
SELECT Spid,net_library,hostname,program_name,nt_domain,nt_username,loginame from sys.sysprocesses
Suppose Spid=100,kill 100
SQL Server deletes user 15434 error