monProcessActivity

Description

Provides detailed statistics about process activity.

Enable the enable monitoring 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		(Cluster environments only) 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. The value is a sum of regular and tempdb user log cache.
ULCFlushFull	int	Counter	Number of times the user log cache was flushed because it was full. The value is a sum of regular and tempdb user log cache.
ULCMaxUsage	int		The maximum usage (in bytes) of the user log cache by the process. The value is a sum of regular and tempdb user log cache.
ULCCurrentUsage	int		The current usage (in bytes) of the user log cache by the process. The value is a sum of regular and tempdb user log cache.
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.
HostName	varchar(30)	Null	Name of the host machine on which the application that executed the query is running.
Application	varchar(30)	Null	Name of the application.
ClientName	varchar(30)	Null	Value of the clientname property set by the application.
ClientHostName	varchar(30)	Null	Value of the clienthostname property set by the application.
ClientApplName	varchar(30)	Null	Value of the clientapplname property set by the application.