![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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 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 | Number of procedure cache pages allocated to the process (1 page equals 8 kilobytes) |
| 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 | Displays detailed information related to a particular database on Microsoft SQL Server. To display this report, click the DB Name field. |
| Session Detail | Displays detailed information related to resource usage by each session. To display this report, click one of the following fields:
|
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.