The Locked Sessions view shows which problem locks are causing data availability problems and unacceptable responses. 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:
Right-click any of these charts and either print, save as an 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.
You can open the Locks view of the SQL Diagnostic Manager Sessions tab by selecting the appropriate SQL Server instance and clicking Sessions > Locks.
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.
| | | | | | | |