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. |
Scroll pdf ignore | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Diagnostics Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| ||||||||||||||||||||||||||||||||||||||||||||||||||
Newtabfooter | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal