Hitachi

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


System Overview (9.0)

Organization of this page

Overview

The System Overview (9.0) report displays detailed information related to Microsoft SQL Server. The information is displayed as a list and as a line graph. From the displayed report, you can display more detailed drilldown reports.

Storage location

Reports/SQL/Status Reporting/Real-Time/

Record

Server Detail (PD)

Fields

Field name

Description

Blocked Processes

Number of blocked processes

Blocking Locks

Number of blocking locks

Boot Time

Server boot date

Cache Hit %

Rate at which data pages were found inside the data cache during an interval

Conns

Number of client connections

CPU %

Percentage of time CPU is busy

This field cannot display correct value.

Database Count

Number of databases

Host OS

OS that is running Microsoft SQL Server

Host Type

Type of machine on which Microsoft SQL Server is running.

Either of the following values is displayed:

  • For the 32-bit and 64-bit (IPF) versions of Microsoft SQL Server: Intel

  • For the 64-bit version of Microsoft SQL Server (x64): X64

I/O %

Percentage of CPU time spent for I/O

This field cannot display correct value.

Idle %

Percentage of time CPU is idle

This field cannot display correct value.

Locks

Total number of locks

Pkt Errors

Number of packet errors

Pkts Rcvd

Number of packets received

Pkts Sent

Number of packets sent

Server Name

Name of the machine on which Microsoft SQL Server is running

Total Errors

Number of disk errors

Total Reads

Number of disk read operations

Total Writes

Number of disk write operations

Version

Microsoft SQL Server version

Drilldown reports (report level)

Report name

Description

Database Space Usage (9.0)

Displays information related to space usage in each database in Microsoft SQL Server.

Lock Overview (8.0)

Displays the overview of locks in the entire instance as a total number of database locks being maintained.

Log Space Usage - Top 10 Databases

Displays information related to the top 10 databases that are currently consuming the largest amounts of log space.

Server Configuration Status

Displays information related to environment setting parameter values for Microsoft SQL Server.

Server Space Usage (9.0)

Displays statistics information related to the overall space usage in Microsoft SQL Server.

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.

CPU Usage - Top 10 Sessions (8.0)

Displays information related to the top 10 sessions that are currently using the largest numbers of CPU cycles. To display this report, click the CPU % field.

Database Summary (8.0)

Displays detailed information related to the statuses of all databases in Microsoft SQL Server. To display this report, click the Database Count field.

Errorlog Overview

Displays information related to the top 10 sessions that currently have the largest numbers of locks on database objects. To display this report, click the Locks field.

Lock Usage - Top 10 Sessions (8.0)

Displays information related to the top 10 sessions that are currently using the largest amounts of memory. To display this report, click the Cache Hit % field.

Memory Usage - Top 10 Sessions (8.0)

Displays statistics information related to network activities on a minute-by-minute basis over the past hour. To display this report, click one of the following fields:

  • Pkt Errors

  • Pkts Rcvd

  • Pkts Sent

Network Activity

Displays information related to the top 10 sessions that are currently executing the largest number of disk read/write operations. To display this report, click the I/O % field.

Physical I/O - Top 10 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.