monProcessActivity

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 the SAP ASE server retrieved without using an index.
`IndexAccesses`	`int`	Counter	Number of pages read that the SAP ASE 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.
`IOSize1Page`	`int`		Number of IO operations performed for each IO one page in size.
`IOSize2Page`	`int`		Number of IO operations performed for each IO that is 2 pages in size.
`IOSize4Page`	`int`		Number of IO operations performed for each IO that is 4 pages is size.
`IOSize8Page`	`int`		Number of IO operations performed for each IO that is 8 pages in size.
`HeapMemoryInUseKB`	`int`		Current amount, in kilobytes, of heap memory in use.
`HeapMemoryUsedHWM_KB`	`int`		Maximum amount, in kilobytes, of heap memory used (the high water mark).
`HeapMemoryReservedKB`	`int`		Amount, in kilobytes, of heap memory reserved.
`HeapMemoryAllocs`	`int`		Amount, in kilobytes, of heap memory allocated.