Jasinski Technical Wiki


Home Page
All Pages

Quick Search
Advanced Search »

Contributor Links

Create a new Page
File Management
Your Profile

Other Wiki Sections



sysprocesses System Table - SQL Server 2000

Modified on Fri, May 01, 2009, 11:02 AM by Administrator Categorized as SQL Server System Tables
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 nameData typeDescription
spidsmallintSQL Server process ID.
kpidsmallintMicrosoft Windows NT 4.0® thread ID.
blockedsmallintProcess ID (spid) of a blocking process.
waittimeintCurrent wait time in milliseconds. Is 0 when the process is not waiting.
lastwaittypenchar(32)A string indicating the name of the last or current wait type.
waitresourcenchar(32)Textual representation of a lock resource.
dbidsmallintID of the database currently being used by the process.
uidsmallintID of the user who executed the command.
cpuintCumulative 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_iointCumulative disk reads and writes for the process.
memusageintNumber 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_timedatetimeTime at which a client process logged into the server. For system processes, the time at which SQL Server startup occurred is stored.
last_batchdatetimeLast 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.
ecidsmallintExecution context ID used to uniquely identify the subthreads operating on behalf of a single process.
open_transmallintNumber of open transactions for the process.
statusnchar(30)Process ID status (for example, running, sleeping, and so on).
sidbinary(85)Globally unique identifier (GUID) for the user.
hostnamenchar(128)Name of the workstation.
program_namenchar(128)Name of the application program.
hostprocessnchar(8)Workstation process ID number.
cmdnchar(16)Command currently being executed.
nt_domainnchar(128)Windows NT 4.0 domain for the client (if using Windows Authentication) or a trusted connection.
nt_usernamenchar(128)Windows NT 4.0 user name for the process (if using Windows Authentication) or a trusted connection.
net_addressnchar(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_librarynchar(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.
loginamenchar(128)Login name.

ScrewTurn Wiki version Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2023, Patrick Jasinski.