The Uptime Infrastructure Monitor SQL Server Advanced Metrics monitor collects the following performance metrics from a SQL Server database:

MetricExplanationPerformance 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 TimeThe average time, in milliseconds, that it takes for database locks to clear.SQL ServerLocks
User ConnectionsThe 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 / KBThe cumulative size of all the files in all of the databases on the host system.SQL ServerDatabases
Total Latch Wait TimeThe 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 TimeThe average time, in milliseconds, that latch requests had to wait before being granted.SQLServerLatches
Maximum Workspace MemoryThe 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 MemoryThe total amount of dynamic memory, in kilobytes, that the server is using to maintain connections.SQL ServerMemory Manager
SQL Cache MemoryThe amount of memory, in kilobytes, that the server is using for the dynamic SQL cache.SQL ServerMemory Manager
Total Server MemoryThe total amount of committed memory from the buffer pool, in kilobytes, that the server is using.SQL ServerMemory Manager