sysprocesses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
spid smallint 2 null
kpid smallint 2 null
blocked smallint 2 null
waittype binary 2 null
waittime bigint 8 null
lastwaittype nchar 64 null
waitresource nchar 512 null
dbid smallint 2 null
uid smallint 2 √ null
cpu int 4 null
physical_io bigint 8 null
memusage int 4 null
login_time datetime 16,3 null
last_batch datetime 16,3 null
ecid smallint 2 null
open_tran smallint 2 null
status nchar 60 null
sid binary 86 null
hostname nchar 256 null
program_name nchar 256 null
hostprocess nchar 20 null
cmd nchar 52 null
nt_domain nchar 256 null
nt_username nchar 256 null
net_address nchar 24 null
net_library nchar 24 null
loginame nchar 256 null
context_info binary 128 null
sql_handle binary 20 null
stmt_start int 4 null
stmt_end int 4 null
request_id int 4 null
page_resource varbinary 8 √ null

Relationships

Close relationships within degrees of separation