Microsoft SQL Server 2000 Administrators Companion

3 4

This object is used to show SQL Server latch statistics. Latches are internal locking mechanisms used by SQL Server. This object provides information on these internal latches and includes these counters:

• Average Latch Wait Time (ms) Average amount of time, in milliseconds, that a SQL Server thread has to wait for a latch. If this number is high, your system could be experiencing severe contention problems.
• Latch Waits/sec Number of waits for latches per second. If this number is high, your system is experiencing a high amount of contention for resources.
• Total Latch Wait Time (ms) Total amount of time, in milliseconds, that latch requests had to wait in the last second.