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