Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


Session Detail (8.0)

Organization of this page

Overview

The Session Detail (8.0) report displays detailed information related to resource usage in each session. This report is displayed as a list. It is a drilldown report. From the displayed drilldown report, you can display more detailed drilldown reports.

Storage location

Reports/SQL/Troubleshooting/Real-Time/Drilldown Only/

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

Command

Name of the command executed

CPU %

CPU time being used by the process, as a percentage of the CPU time being used by all database processes

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

GID

This field is reserved and cannot be used.

Host

Host computer name

Host PID

Host process ID

Locks

Number of locks being requested 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

Physical I/O

Cumulative number of times the process executed read/write operations to disks

Program

Application program name

SPID

Process ID

Status

Process status

UID

Microsoft SQL Server version 2014 or earlier:

User ID of the user who executed the command

Microsoft SQL Server version 2016 or later:

This field cannot display correct value.

User

Logon name of the user who issued the command

Drilldown reports (field level)

Report name

Description

Blocked Sessions (8.0)

Displays the information related to sessions that are waiting for lock release by other sessions. To display this report, click the Blocked Processes field.

Database Detail (8.0)

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

Lock Detail (8.0)

Displays detailed information related to each lock. To display this report, click the Blocking Process field.