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 nameDescription
Blocked ProcessesNumber of processes blocked by the process
DB NameName of the database being used by the process at the time of record acquisition
LocksNumber of locks being requested by the process at the time of record acquisition
ProgramApplication program name
SPIDProcess ID
UserLogon name of the user who issued the command

Drilldown reports (field level)

Report nameDescription
Session DetailDisplays detailed information related to resource usage in each session. To display this report, click the Locks field.