This report is available only for SQL Server 2000. It provides graphs of SQL Server lock performance counters for specified servers during the specified time period. Performance counter data is averaged by the hour. The graph displays the following lock performance counters:
SQLServer:Locks / Number of Deadlocks Per Second
(Scale=1)SQLServer:Locks / Lock Requests Per Second
(Scale=1/100)SQLServer:Locks / Lock Waits Per Second
(Scale=1/10)The graph displays the following instance for each server/performance counter combination:
Database
Extend
Key
Page
Rid
Table