Lock Usage - Top 10 Sessions
Overview
The Lock Usage - Top 10 Sessions report displays information related to the top 10 sessions that currently have the largest numbers of locks on database objects. This report is displayed as a bar graph. From the displayed report, you can display more detailed drilldown reports.
Storage location
Reports/RM SQLServer/Troubleshooting/Real-Time/
Record
Process Detail (PD_PDET)
Fields
Field name | Description |
---|---|
Blocked Processes | Number of processes blocked by the process |
DB Name | Name of the database being used by the process at the time of record acquisition |
Locks | Number of locks being requested by the process at the time of record acquisition |
Program | Application program name |
SPID | Process ID |
User | Logon name of the user who issued the command |
Drilldown reports (field level)
Report name | Description |
---|---|
Session Detail | Displays detailed information related to resource usage in each session. To display this report, click the Locks field. |