![[Contents]](FIGURE/CONTENT.GIF)
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
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
Overview
The Lock Overview 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/RM SQLServer/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 | 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 | Displays information related to sessions that have locks that are blocking other sessions. To display this report, click the Total Blocking Locks field. |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.