The Lock Waits panel tracks the total number waits caused when a task is waiting to acquire a lock on your monitored SQL Server. Unexpected spikes in the number of lock waits may warn you about the beginning of a serious performance issue. Chronically high lock wait numbers may indicate the need for server maintenance, query tuning, or index updates to better handle the ongoing workload. For additional information, see Analyze locked sessions.

Lock Waits chart

The Lock Waits chart displays the number of waits and the request type occurring.

Metric

Why it is important

Database

Indicates the time waiting for a database lock.

Extent

Indicates the time waiting for an extent lock.

File SQL Server 2005 and above only

Indicates the time waiting for a file lock.

HoBT SQL Server 2005 and above only

Indicates the time waiting for a Heap or BTree lock.

Key SQL Server 2000 only

Indicates the time waiting for a key lock.

Key/RID SQL Server 2005 and above only

Indicates the time waiting for a key or RID lock.

Metadata SQL Server 2005 and above only

Indicates the time waiting for a metadata lock.

Object SQL Server 2005 and above only

Indicates the time waiting for an object lock.

Page

Indicates the time waiting for a page lock.

RID SQL Server 2000 only

Indicates the time waiting for a relative identifier (RID) lock.

Table SQL Server 2000 only

Indicates the time waiting for a table lock.




SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal