monProcessActivity

Description

Provides detailed statistics about process activity. monProcessActivity requires the enable monitoring, wait event timing, and per object statistics active configuration parameters to be enabled.

Columns

Name	Datatype	Attributes	Description
SPID	smallint		Session process identifier
KPID	int		Kernel process identifier
CPUTime	int	counter	CPU time (in milliseconds) used by the process
WaitTime	int	counter	Time (in milliseconds) the process has spent waiting
PhysicalReads	int	counter	Number of buffers read from disk
LogicalReads	int	counter	Number of buffers read from cache
PagesRead	int	counter	Number of pages read
PhysicalWrites	int	counter	Number of buffers written to disk
PagesWritten	int	counter	Number of pages written
MemUsageKB	int		Amount of memory (in bytes) allocated to the process
LocksHeld	int		Number of locks process currently holds
TableAccesses	int	counter	Number of pages where data was retrieved without an index
IndexAccesses	int)	counter	Number of pages where data was retrieved using an index
TempDbAccess	int	counter	Number of temporary tables accessed
ULCBytesWritten	int	counter	Number of bytes written to the user log cache for the process
ULCFlushes	int	counter	Total number of times the user log cache was flushed
ULCFlushFull	int	counter	Number of times the user log cache was flushed because it was full
ULCMaxUsage	int		The maximum ever usage (in bytes) of the user log cache by the process
ULCCurrentUsage	int		The current usage (in bytes) of the Uuer log cache by the process.
Transactions	int	counter	Number of transactions started by the process
Commits	int	counter	Number of transactions committed by the process
Rollbacks	int	counter	Number of transactions rolled back by the process