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

[Contents][Glossary][Index][Back][Next]

Database Detail

Overview

The Database Detail report displays detailed information related to a particular database on Microsoft SQL Server. This report is displayed as a list. This is a drilldown report.

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/

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
Demand Locks Number of request locks
Exclusive Intent Locks Number of exclusive intent locks
Exclusive Page Locks Number of exclusive page locks
Exclusive Table Locks Number of exclusive table locks
Last Dump Date Last dump date for the transaction log
Locks Total number of locks
Options Database option
Other Processes Number of other types of processes
Process Count Total number of processes
Runnable Processes Number of executable processes
Running Processes Number of processes being executed
Shared Intent Locks Number of shared intent locks
Shared Page Locks Number of shared page locks
Shared Table Locks Number of shared table locks
Sleeping Processes Number of sleeping processes
Update Page Locks Number of update page locks
Version Microsoft SQL Server version used for database creation

[Contents][Back][Next]

[Trademarks]

Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.