Page History
...
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. |
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |