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 |
|
|