Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference

[Contents][Glossary][Index][Back][Next]

Lock Overview by Lock Type

Overview

The Lock Overview by Lock Type report displays the overview of locks in the entire instance as the total number of database locks being maintained by lock type.This report is displayed as a list.

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/

Record

Server Locks Detail (PD_LOCK)

Fields

Field name Description
Exclusive Extent Locks Number of exclusive extent locks
Exclusive Intent Locks Number of exclusive intent locks
Exclusive Page Locks Number of exclusive page locks
Exclusive Table Locks Number of exclusive table locks
Shared Intent Locks Number of shared intent locks
Shared Page Locks Number of shared page locks
Shared Table Locks Number of shared table locks
Update Extent Locks Number of update extent locks
Update Page Locks Number of update page locks