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