Muokkaa

Jaa


SQL Server, Wait Statistics object

Applies to: SQL Server

The SQLServer:Wait Statistics performance object contains performance counters that report information about broad categorizations of waits.

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.

Example

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Wait Statistics%';