"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 |