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. |
