Export (0) Print
Expand All

SQL Server: Latches Object

SQL Server 2000

SQL Server: Latches Object

The Latches object in Microsoft® SQL Server™ provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help you to identify performance bottlenecks.

These are the SQL Server Latches counters.

SQL Server Latches counters Description
Average Latch Wait Time (ms) Average latch wait time (in milliseconds) for latch requests that had to wait.
Latch Waits/sec Number of latch requests that could not be granted immediately.
Total Latch Wait Time (ms) Total latch wait time (in milliseconds) for latch requests in the last second.

See Also

Latching

Show:
© 2014 Microsoft