The Uptime Infrastructure Monitor SQL Server Advanced Metrics monitor collects the following performance metrics from a SQL Server database:
| Metric | Description | Performance Object |
|---|---|---|
Lock Wait / Sec. | The amount of time, in seconds, that the server waits for a database lock. | SQL ServerLocks |
Lock Requests / Sec. | The number of new database locks and lock conversions that are requested from the lock manager every second. | SQL ServerLocks |
Average Wait Time | The average time, in milliseconds, that it takes for database locks to clear. | SQL ServerLocks |
User Connections | The number of user connections to the database that are allowed. | SQL ServerGeneral Statistics |
Transactions / Sec. | The number of transactions started for the databases across the host per second. | SQL ServerDatabase |
Data File(s) Size / KB | The cumulative size of all the files in all of the databases on the host system. | SQL ServerDatabases |
Total Latch Wait Time | The total time, in milliseconds, that it takes to complete the latch requests that were waiting over the last second. | SQLServerLatches |
Latch Waits / Sec. | The number of latch requests that were not immediately granted, and which waited before being granted. | SQLServerLatches |
Average Latch Wait Time | The average time, in milliseconds, that latch requests had to wait before being granted. | SQLServerLatches |
Maximum Workspace Memory | The maximum amount of memory, in kilobytes, that the server has available to execute such processes as sort, bulk copy, hash, and index creation. | SQL ServerMemory Manager |
Connection Memory | The total amount of dynamic memory, in kilobytes, that the server is using to maintain connections. | SQL ServerMemory Manager |
SQL Cache Memory | The amount of memory, in kilobytes, that the server is using for the dynamic SQL cache. | SQL ServerMemory Manager |
Total Server Memory | The total amount of committed memory from the buffer pool, in kilobytes, that the server is using. | SQL ServerMemory Manager |