System Overview

Overview

The System Overview 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/RM SQLServer/Status Reporting/Real-Time/

Record

Server Detail (PD)

Fields

Field nameDescription
Blocked ProcessesNumber of blocked processes
Blocking LocksNumber of blocking locks
Boot TimeServer boot date
Cache Hit %Rate at which data pages were found inside the data cache during an interval
ConnsNumber of client connections
CPU %Percentage of time CPU is busy
Database CountNumber of databases
Host OSOS that is running Microsoft SQL Server
Host TypeType 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
Idle %Percentage of time CPU is idle
LocksTotal number of locks
Pkt ErrorsNumber of packet errors
Pkts RcvdNumber of packets received
Pkts SentNumber of packets sent
Server NameName of the machine on which Microsoft SQL Server is running
Total ErrorsNumber of disk errors
Total ReadsNumber of disk read operations
Total WritesNumber of disk write operations
VersionMicrosoft SQL Server version

Drilldown reports (report level)

Report nameDescription
Database Space UsageDisplays information related to space usage in each database in Microsoft SQL Server.
Lock OverviewDisplays the overview of locks in the entire instance as a total number of database locks being maintained.
Log Space Usage - Top 10 DatabasesDisplays information related to the top 10 databases that are currently consuming the largest amounts of log space.
Server Configuration StatusDisplays information related to environment setting parameter values for Microsoft SQL Server.
Server Space UsageDisplays statistics information related to the overall space usage in Microsoft SQL Server.

Drilldown reports (field level)

Report nameDescription
Blocked SessionsDisplays the information related to sessions that are waiting for lock release by other sessions. To display this report, click the Blocked Processes field.
Blocking LocksDisplays 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 SessionsDisplays 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 SummaryDisplays detailed information related to the statuses of all databases in Microsoft SQL Server. To display this report, click the Database Count field.
Errorlog OverviewDisplays the overview of all errors that occurred in Microsoft SQL Server in the last interval. To display this report, click the Total Errors field.
Lock Usage - Top 10 SessionsDisplays 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.
Memory Usage - Top 10 SessionsDisplays 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.
Network ActivityDisplays 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
Physical I/O - Top 10 SessionsDisplays 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.