Page History

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