You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
\n
\n
\nRelated Documentation |
\nVersion of up.time
\naffected |
\nAffected Platforms |
\n
\n
\n
\n |
\nAll |
\nAll |
\n
\n
\n
\n
\n
The up.time SQL Server Advanced Metrics monitor collects the following performance metrics from a SQL Server database:
\n
\n
\n
\n\tMetric |
\n\tExplanation |
\n\tPerformance Object |
\n
\n
\n\tLock Wait / Sec. |
\n\tThe amount of time, in seconds, that the server waits for a database lock. |
\n SQL ServerLocks |
\n
\n
\n\tLock Requests / Sec. |
\n\tThe number of new database locks and lock conversions that are requested from the lock manager every second. |
\n SQL ServerLocks |
\n
\n
\n\tAverage Wait Time |
\n\tThe average time, in milliseconds, that it takes for database locks to clear. |
\n SQL ServerLocks |
\n
\n
\n\tUser Connections |
\n\tThe number of user connections to the database that are allowed. |
\n SQL ServerGeneral Statistics |
\n
\n
\n\tTransactions / Sec. |
\n\tThe number of transactions started for the databases across the host per second. |
\n SQL ServerDatabase |
\n
\n
\n\tData File(s) Size / KB |
\n\tThe cumulative size of all the files in all of the databases on the host system. |
\n SQL ServerDatabases |
\n
\n
\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. |
\n SQLServerLatches |
\n
\n
\n\tLatch Waits / Sec. |
\n\tThe number of latch requests that were not immediately granted, and which waited before being granted. |
\n SQLServerLatches |
\n
\n
\n
\n\tAverage Latch Wait Time |
\n\tThe average time, in milliseconds, that latch requests had to wait before being granted. |
\n SQLServerLatches |
\n
\n
\n\tMaximum 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. |
\n SQL ServerMemory Manager |
\n
\n
\n\tConnection Memory |
\n\tThe total amount of dynamic memory, in kilobytes, that the server is using to maintain connections. |
\n SQL ServerMemory Manager |
\n
\n
\n SQL Cache Memory |
\n\tThe amount of memory, in kilobytes, that the server is using for the dynamic SQL cache. |
\n SQL ServerMemory Manager |
\n
\n
\n\tTotal Server Memory |
\n\tThe total amount of committed memory from the buffer pool, in kilobytes, that the server is using. |
\n SQL ServerMemory Manager |
\n
\n
\n