Navigation

	Home Page
	Index
	All Pages

Quick Search
Advanced Search »

Contributor Links

	Create a new Page
	Administration
	File Management
	Login/Logout
	Your Profile

Other Wiki Sections

Software

sysprocesses System Table - SQL Server 2000

This table holds information about processes running on Microsoft® SQL Server™, both client processes and system processes. This table 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.
loginame	nchar(128)	Login name.