System Overview

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

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: 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
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

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.

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: Pkt Errors Pkts Rcvd Pkts Sent
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.