System Overview (7.0)
- Organization of this page
Overview
The System Overview (7.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/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 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:
|
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 (7.0) |
Displays information related to space usage in each database in Microsoft SQL Server. |
Lock Overview (6.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 (7.0) |
Displays statistics information related to the overall space usage in Microsoft SQL Server. |
Drilldown reports (field level)
Report name |
Description |
---|---|
Blocked Sessions (6.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 (6.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 (6.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 (6.0) |
Displays detailed information related to the statuses of all databases in Microsoft SQL Server. To display this report, click the Database Count field. |
Lock Usage - Top 10 Sessions (6.0) |
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 (6.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. |
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 (6.0) |
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. |