![[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 Blocking Locks report displays information related to sessions that have locks that are blocking other sessions. This report is displayed as a table. From the displayed report, you can display more detailed drilldown reports.
Storage location
Reports/RM SQLServer/Troubleshooting/Real-Time/
Record
Lock Detail (PD_LD)
Fields
| Field name | Description |
|---|---|
| Blocking Flag | This flag indicates whether or not the lock is a blocking lock. The following values are valid:
|
| DB Name | Database name related to lock resource |
| Demand Flag | This flag indicates whether or not the lock is a request lock. The following values are valid:
|
| Lock Type | Lock type (lock request mode and lock resource type) |
| Orphan Flag | This flag indicates whether or not the lock is an isolated lock. The following values are valid:
|
| Program | Name of the application program that is requesting the lock |
| SPID | Process ID that is requesting the lock |
| Table | Table name if the lock resource is a table or row |
| User | Logon name of the user who issued the command |
Drilldown reports (field level)
| Report name | Description |
|---|---|
| Lock Detail | Displays detailed information related to each lock. To display this report, click the Lock Type field. |
| Session Detail | Displays detailed information related to resource usage status in each session. To display this report, click the SPID field. |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.