On the Locked Sessions view, you can see which problem locks are causing data availability problems and unacceptable responses. By combining the information provided on the Problem Locks view (including the type of Lock) with the Lock Statistics: Waits chart on the Sessions Summary tab, you can pinpoint, correct, or reschedule automated applications that cause extensive row, table, or database locking.
Use the drop-down list in the chart title to select charts that include:
- Average Wait Time
- Wait Time information
You can right-click any of these and either print, save as image, or export them to Microsoft Excel. In addition, you can select Toolbar for advanced customization options such as changing the chart color scheme and the type of chart shown.
Access the Locks view
You can open the Locks view of the SQL Diagnostic Manager Sessions tab by selecting the appropriate SQL Server instance, and then clicking Sessions > Locks .
Available SQL Server lock objects
The Lock Statistics chart includes the following objects:
Represents a lock on an allocation unit.
Represents a lock on an application-specific resource.
Represents a lock on a database, including all objects in the database.
Represents a lock on a contiguous group of eight pages.
Represents a lock on a database file.
(Heap or BTree) Represents a lock on a heap of data pages, or on the BTree structure of an index.
Represents a lock on a row in an index.
Represents a lock on a latch.
Represents a lock on a piece of catalog information, also called metadata.
Represents a lock on an item such as a table, stored procedure, or view, including all data and indexes. The object represents anything that has an entry in sys.all_objects.
Represents a lock on an 8 KB page in a database.
(Row ID) Represents a lock on a single row in a heap.
Represents a lock on a table.