Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


Lock Overview (8.0)

Organization of this page

Overview

The Lock Overview (8.0) report displays the overview of locks in the entire instance as the total number of database locks being maintained. This report is displayed as a list. From the displayed report, you can display more detailed drilldown reports.

Storage location

Reports/SQL/Troubleshooting/Real-Time/

Record

Server Locks Detail (PD_LOCK)

Fields

Field name

Description

Total Blocking Locks

Number of locks that are blocking other processes

Total Exclusive Locks

Total number of exclusive locks

Total Extent Locks

Total number of extent locks

Total Intent Locks

Total number of intent locks

Total Locks

Total number of locks being used by Microsoft SQL Server

Total Page Locks

Total number of page locks

Total Shared Locks

Total number of shared locks

Total Table Locks

Total number of table locks

Users Blocked

Number of users who are blocked by other users

Drilldown reports (report level)

Report name

Description

Lock Overview by Lock Type

Displays the overview of locks in the entire instance as the total numbers of database locks being maintained by lock type.

Drilldown reports (field level)

Report name

Description

Blocked Sessions (8.0)

Displays the information related to sessions that are waiting for lock release by other sessions. To display this report, click the Users Blocked field.

Blocking Locks (8.0)

Displays information related to sessions that have locks that are blocking other sessions. To display this report, click the Total Blocking Locks field.