Table name | Record ID | Record No. | Field Name | Source | Unit of Measure | Description |
|---|---|---|---|---|---|---|
resource_data | SQLS_ACCMD | 1068 | paccis | MSSQL | searches | Number of scans of index per second (count)<total> |
paccfs | MSSQL | scans | Number of full scans of table or index per second (count)<total> | |||
paccfss | MSSQL | scans | Number of scans of free space for adding a new record fragment (count)<total> | |||
sqls_accmd_objname | MSSQL | Performance counter object name | ||||
sqls_accmd_appname | MSSQL | SQL Server Instance name | ||||
resource_data_wide | SQLS_BFMGR | 1069 | pbmbch | MSSQL | hits | Buffer Cache Hits (count)<total> |
pbmbchb | MSSQL | Accesses | Buffer Cache Hits Base (count)<total> | |||
pbmchw | MSSQL | pages | Checkpoint Pages (count)<total> | |||
pbmprd | MSSQL | reads | Page Reads (count)<total> | |||
pbmpwr | MSSQL | writes | Page Writes (count)<total> | |||
pbmspg | MSSQL | pages | Target Pages (count)<total> | |||
pbmtpg | MSSQL | pages | Total Page Count (snapshot)<total> | |||
sqls_bfmgr_objname | MSSQL | Performance counter object name | ||||
sqls_bfmgr_ appname | MSSQL | SQL Server Instance name | ||||
resource_data | SQLS_CMGR | 1070 | pcmchr | MSSQL | hits | Cache Hit Ratio (count)<total> |
pcmchrb | MSSQL | hits | Cache Hits Ration Base (count)<total> | |||
sqls_cmgr_objname | MSSQL | Performance counter object name | ||||
sqls_cmgr_appname~ | MSSQL | SQL Server Instance name | ||||
resource_data_wide | SQLS_DB | 1071 | pdbat | MSSQL | transactions | Active Transactions (snapshot)<total> |
pdblft | MSSQL | milliseconds | Log Flush Wait Time (snapshot)<total> | |||
pdblfw | MSSQL | waits | Log Flush Waits (count)<total> | |||
pdbplu | MSSQL | percent | Percent Log Used (count)<total> | |||
pdbtra | MSSQL | transactions | Transactions (count)<total> | |||
sqls_db_objname | MSSQL | Performance counter object name | ||||
sqls_gs_appname~ | MSSQL | SQL Server Instance name | ||||
resource_data | SQLS_GS | 1072 | pgsuc | MSSQL | connections | User Connections (snapshot)<average> |
sqls_gs_objname | MSSQL | Performance counter object name | ||||
sqls_lo_appname~ | MSSQL | SQL Server Instance name | ||||
resource_data | SQLS_LO | 1074 | plolwt | MSSQL | milliseconds | Lock Wait Time (ms) (count)<total> |
plolws | MSSQL | waits | Lock Waits (count)<total> | |||
plodlk | MSSQL | Deadlocks | Number of Deadlocks (count)<total> | |||
sqls_lo_objname | MSSQL | Performance counter object name | ||||
sqls_lo_appname~ | MSSQL | SQL Server Instance name | ||||
resource_data | SQLS_MMGR | 1075 | pmmttm | MSSQL | KBs | Total Server Memory (KB) (snapshot)<total> |
sqls_mmgr_objname | MSSQL | Performance counter object name | ||||
sqls_mmgr_appname | SQL Server Instance name | |||||
resource_data | SQLS_STATS | 1098 | pstatrc | MSSQL | re-compilations | SQL Re-Compilations (count) <total> |
pstatbr | MSSQL | requests | Batch Requests (count) <total> | |||
sqls_stats_objname | MSSQL | Performance counter object name | ||||
sqls_stats_appname | MSSQL | SQL Server Instance name |
