Sessions (6.0)

Organization of this page

Overview
Storage location
Record
Fields
Drilldown reports (field level)

Overview

The Sessions (6.0) 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.

To Page Top

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/

To Page Top

Record

Process Detail (PD_PDET)

To Page Top

Fields

Field name	Description
Blocked Processes	Number of processes blocked by the process
Blocking Process	Process ID of a blocking process, if any
DB Name	Name of the database being used by the process at the time of record acquisition
DBID	Database ID being used by the process at the time of record acquisition
Mem Usage	Microsoft SQL Server version 2014 or earlier: Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes) Microsoft SQL Server version 2016 or later: Number of pages of memory used in the process
Program	Application program name
SPID	Process ID
User	Logon name of the user who issued the command

To Page Top

Drilldown reports (field level)

Report name	Description
`Database Detail (6.0)`	Displays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field.
`Session Detail (6.0)`	Displays detailed information related to resource usage by each session. To display this report, click one of the following fields: Blocking Process SPID

Report name

Description

Database Detail (6.0)

Displays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field.

Session Detail (6.0)

Displays detailed information related to resource usage by each session. To display this report, click one of the following fields:

Blocking Process
SPID

To Page Top