Sessions (6.0)
- Organization of this page
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.
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 |
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 |
|
Program |
Application program name |
SPID |
Process ID |
User |
Logon name of the user who issued the command |
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:
|