Processes

All - Columns

Name	Description
SPID	Session ID
Login Name	Login name
Process Status	Status: dormant running background rollback pending runnable spinloop suspended
Command	General command type being executed
Program Name	Application name
Physical IOs / Sec	Number of physical I/O operations per second, in interval
Phys IO	Number of physical I/O operations (disk reads + writes)
Memory Blks	Memory usage, in pages (pagesize is 8 KB)
CPU Time	CPU time
Blk By	Blocker session ID, if applicable; may be negative in special circumstances
Wait Resource	Text description of the wait resource; for example, a description of the RID that is locked
Wait Time	Duration of time blocked
Database Name	Database name
Hostname	Client host name
Host Proc ID	Client OS PID
Login Time	Text description of login time
Last Batch Time	Text description of last batch statement time
# of Open Tran	Number of open transactions
Windows Domain	Windows domain of the client
Windows User Name	Windows user name of the client

Name	Description
SPID	Session ID
Login Name	Login name
Process Status	Status: dormant running background rollback pending runnable spinloop suspended
Command	General command type being executed
Program Name	Application name
Physical IOs / Sec	Number of physical I/O operations per second, in interval
Phys IO	Number of physical I/O operations (disk reads + writes)
Memory Blks	Memory usage, in pages (pagesize is 8 KB)
CPU Time	CPU time
Blk By	Blocker session ID, if applicable; may be negative in special circumstances
Wait Resource	Text description of the wait resource; for example, a description of the RID that is locked
Wait Time	Duration of time blocked
Database Name	Database name
Hostname	Client host name
Host Proc ID	Client OS PID
Login Time	Text description of login time
Last Batch Time	Text description of last batch statement time
# of Open Tran	Number of open transactions
Windows Domain	Windows domain of the client
Windows User Name	Windows user name of the client

Name	Description
SPID	Session ID
Login Name	Login name
Process Status	Status: dormant running background rollback pending runnable spinloop suspended
Command	General command type being executed
Program Name	Application name
Physical IOs / Sec	Number of physical I/O operations per second, in interval
Phys IO	Number of physical I/O operations (disk reads + writes)
Memory Blks	Memory usage, in pages (pagesize is 8 KB)
CPU Time	CPU time
Blk By	Blocker session ID, if applicable; may be negative in special circumstances
Wait Resource	Text description of the wait resource; for example, a description of the RID that is locked
Wait Time	Duration of time blocked
Database Name	Database name
Hostname	Client host name
Host Proc ID	Client OS PID
Login Time	Text description of login time
Last Batch Time	Text description of last batch statement time
# of Open Tran	Number of open transactions
Windows Domain	Windows domain of the client
Windows User Name	Windows user name of the client

Name	Description
Database Name	Database name
Sessions	Number of sessions
Active Sessions	Number of sessions in the running state
Transactions	Number of open transactions over all sessions
Inactive Transactions	Number of open transactions over all inactive sessions
Memory	Memory usage over all sessions

Name	Description
SPID	Session ID
Login Name	Login name
Process Status	Status: dormant running background rollback pending runnable spinloop suspended
Command	General command type being executed
Program Name	Application name
Physical IOs / Sec	Number of physical I/O operations per second, in interval
Phys IO	Number of physical I/O operations (disk reads + writes)
Memory Blks	Memory usage, in pages (pagesize is 8 KB)
CPU Time	CPU time
Blk By	Blocker session ID, if applicable; may be negative in special circumstances
Wait Resource	Text description of the wait resource; for example, a description of the RID that is locked
Wait Time	Duration of time blocked
Database Name	Database name
Hostname	Client host name
Host Proc ID	Client OS PID
Login Time	Text description of login time
Last Batch Time	Text description of last batch statement time
# of Open Tran	Number of open transactions
Windows Domain	Windows domain of the client
Windows User Name	Windows user name of the client

Name	Description
Login Name	Login name
Sessions	Number of sessions
Active Sessions	Number of sessions in the running state
Transactions	Number of open transactions over all sessions
Inactive Transactions	Number of open transactions over all inactive sessions
Memory	Memory usage over all sessions

Name	Description
SPID	Session ID
Login Name	Login name
Process Status	Status: dormant running background rollback pending runnable spinloop suspended
Command	General command type being executed
Program Name	Application name
Physical IOs / Sec	Number of physical I/O operations per second, in interval
Phys IO	Number of physical I/O operations (disk reads + writes)
Memory Blks	Memory usage, in pages (pagesize is 8 KB)
CPU Time	CPU time
Blk By	Blocker session ID, if applicable; may be negative in special circumstances
Wait Resource	Text description of the wait resource; for example, a description of the RID that is locked
Wait Time	Duration of time blocked
Database Name	Database name
Hostname	Client host name
Host Proc ID	Client OS PID
Login Time	Text description of login time
Last Batch Time	Text description of last batch statement time
# of Open Tran	Number of open transactions
Windows Domain	Windows domain of the client
Windows User Name	Windows user name of the client

Attributes:	None
Minimum database version:	9.0