Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


Lock Overview by Lock Type

Organization of this page

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