SQL Server, Wait Statistics Object
The SQLServer:Wait Statistics performance object contains performance counters that report information about wait status.
The table below lists the counters that the Wait Statistics object contains.
| SQL Server Wait Statistics counters | Description |
|---|---|
| Lock waits | Statistics for processes waiting on a lock. |
| Log buffer waits | Statistics for processes waiting for log buffer to be available. |
| Log write waits | Statistics for processes waiting for log buffer to be written. |
| Memory grant queue waits | Statistics for processes waiting for memory grant to become available. |
| Network IO waits | Statistics relevant to wait on network I/O. |
| Non-Page latch waits | Statistics relevant to non-page latches. |
| Page IO latch waits | Statistics relevant to page I/O latches. |
| Page latch waits | Statistics relevant to page latches, not including I/O latches. |
| Thread-safe memory objects waits | Statistics for processes waiting on thread-safe memory allocators. |
| Transaction ownership waits | Statistics relevant to processes synchronizing access to transaction. |
| Wait for the worker | Statistics relevant to processes waiting for worker to become available. |
| Workspace synchronization waits | Statistics relevant to processes synchronizing access to workspace. |
Each counter in the object contains the following instances:
| Item | Description |
|---|---|
| Average wait time (ms) | Average time for the selected type of wait. |
| Cumulative wait time (ms) per second | Aggregated wait time per second, for the selected type of wait. |
| Waits in progress | Number of processes currently waiting on the following type. |
| Waits started per second | Number of waits started per second of the selected type of wait. |