Hitachi

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


Database Summary (8.0)

Organization of this page

Overview

The Database Summary (8.0) report displays detailed information related to the statuses of all databases in Microsoft SQL Server. This report is displayed as a table. From the displayed report, you can display more detailed drilldown reports.

Storage location

Reports/SQL/Troubleshooting/Real-Time/

Record

Database Detail (PD_DD)

Fields

Field name

Description

Availability

Database status. The following values are valid:

Active

Enabled. Process is running.

Available

Enabled. No process is running.

NOT Available

A crash or problem may have occurred during loading, and as a result the database cannot be opened or used in its current state.

Restricted

Database can be used only by its owner or a single user.

Blocked Processes

Number of blocked processes

Blocking Locks

Number of blocking locks

Create Date

Database creation date

DB Name

Database name

DB Owner

Database owner

DBID

Database ID

Last Dump Date

Last dump date for the transaction log

Locks

Total number of locks

Process Count

Total number of processes

Version

Microsoft SQL Server version 2014 or earlier:

Microsoft SQL Server version used for database creation

Microsoft SQL Server version 2016 or later:

Value indicating the version of Microsoft SQL Server with operational compatibility

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.

Blocking Locks (8.0)

Displays information related to sessions that have locks that are blocking other sessions. To display this report, click the Blocking Locks 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.

Sessions (8.0)

Displays information related to the statuses of all processes connected to Microsoft SQL Server. To display this report, click the Process Count field.