SQLActivity Data Collector

"SQLActivity" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - SQL activity (Q).

To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below, and visit Alert Configuration.

Alertable Metric ProTop RT Label Data Type Description
tt_SQL     (temptable name)
dbAccess Blk Acc num Number of database blocks accessed, both reads and writes
hitRatio Hit% num Number of record reads from memory buffers expressed as a percentage of all record reads
lastUpd CSC Age char If enabled, the number of seconds since the user's Client Statement Cache (CSC) was last updated
lkHWM Lk HWM num Lock table concurrent locks high watermark
osReads OS Rd num Number of record reads from the OS (disk)
osWrites OS Wr num Number of record writes to the OS (disk)
procName SQL Query char Name of the SQL query being run
recLks Rec Lck num Number of record locks held by the query
userFlags Flags char see ProTop Real-Time - SQL activity (Q)
userName Name char Name associated with Usr#
userNum Usr# num Database User connection number
userPID PID char OS Process ID