...
...
| Related Documentation | \nVersion of up.time \naffected | \naffected | Affected Platforms | \n||
| All | \n\n | \nAll | \nAll | \n
...
The up.time SQL Server Advanced Metrics monitor collects the following performance metrics from a SQL Server database:
...
\n \n\tMetric \n\tExplanation \n\tPerformance Object \n \n \n\t
\n\t
\n
\n \n \n\t
\n\t
\n
\n \n \n\t
\n\t
\n
\n \n \n\t
\n\t
\n
\n \n \n\t
\n\t
\n
\n \n \n\t
\n\t
\n
\n \n \n
\n\t
\n
\n
\n \n\t
\n\t
\n \n \n \n\t
\n
\n\t
\n
\n \n \n\t
\n\t
\n \n \n\t
\n
\n\t
\n
\n \n \n
\n\t
\n
\n \n \n\t
\n\t
\n
\n \n \n
| 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 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 |