Sessions

Overview

The Sessions report displays information related to the statuses of all processes connected to Microsoft SQL Server. 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

Process Detail (PD_PDET)

Fields

Field nameDescription
Blocked ProcessesNumber of processes blocked by the process
Blocking ProcessProcess ID of a blocking process, if any
DB NameName of the database being used by the process at the time of record acquisition
DBIDDatabase ID being used by the process at the time of record acquisition
Mem UsageNumber of procedure cache pages allocated to the process (1 page equals 8 kilobytes)
ProgramApplication program name
SPIDProcess ID
UserLogon name of the user who issued the command

Drilldown reports (field level)

Report nameDescription
Database DetailDisplays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field.
Session DetailDisplays detailed information related to resource usage by each session. To display this report, click one of the following fields:
  • Blocking Process
  • SPID