The Uptime Infrastructure Monitor SQL Server Advanced Metrics monitor collects the following performance metrics from a SQL Server database:
Metric |
Explanation |
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 |
Data File(s) Size / KB |
The cumulative size of all the files in all of the databases on the host system. |
SQL |
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 |