Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.