monProcessActivity

Description

Provides detailed statistics about process activity.

Enable the enable monitoring, object lockwait timing, and wait event timing configuration parameters for this monitoring table to collect data.

Columns

The columns for monProcessActivity are:

Name	Datatype	Attributes	Description
SPID	smallint		Session process identifier.
InstanceID	int		Specific to cluster environments – ID of an instance in a shared-disk cluster.
KPID	int		Kernel process identifier.
ServerUserID	int		Server user identifier (SUID) of the user running this process. The value in ServerUserID matches the syslogins.suid column. Use the suser_name function to obtain the corresponding name.
CPUTime	int	Counter	CPU time (in milliseconds) used by the process.
WaitTime	int	Counter	Time (in milliseconds) the process 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 read that Adaptive Server retrieved without using an index.
IndexAccesses	int	Counter	Number of pages read that Adaptive Server retrieved using an index.
WorkTables	int	Counter	Total number of work tables the process created.
TempDbObjects	int	Counter	Total number of temporary tables the process created.
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 usage (in bytes) of the user log cache by the process.
ULCCurrentUsage	int		The current usage (in bytes) of the user 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.