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 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 |
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:
|
I/O % | Percentage of CPU time spent for I/O |
Idle % | Percentage of time CPU is idle |
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 | Displays information related to space usage in each database in Microsoft SQL Server. |
Lock Overview | 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 | Displays statistics information related to the overall space usage in Microsoft SQL Server. |
Drilldown reports (field level)
Report name | Description |
---|---|
Blocked Sessions | 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 | 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 | 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 | 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 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 Sessions | 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. |
Memory Usage - Top 10 Sessions | 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. |
Network Activity | 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:
|
Physical I/O - Top 10 Sessions | 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. |