MS SQL Server Unified Dashboard

The MS SQL Server Unified Dashboard provides predefined list views with information about your MS SQL server, such as load, locks, performance reports and list designer, server processes, database performance and user statistics. 
uim901
sql_server_UD
The MS SQL Server Unified Dashboard provides predefined list views with information about your MS SQL server, such as load, locks, performance reports and list designer, server processes, database performance and user statistics. 
Contents 
If your Unified Dashboard is not populating with data, make sure all required data sources for the Unified Dashboard are enabled. The required probe must be deployed and must be configured so that required QoS metrics and subkeys or targets are activated. For more information, see the help topic on required data sources for the Unified Dashboard.
MS SQL Server Required Data Sources
This table lists the probes, QoS metrics, and subkeys or targets that must be activated to populate data in the MS SQL Server dashboard.
Probe
QoS
Subkey/Target
sqlserver
QOS_SQLSERVER_FG_FREESPACE_WITH_AVAIL_DISK
Free Space with Avail Disk
QOS_SQLSERVER_ACTIVE_USERS
*
QOS_SQLSERVER_BLOCKED_USERS
*
QOS_SQLSERVER_BUF_CACHEHIT_RATIO
*
QOS_SQLSERVER_CHECK_DBALIVE
*
QOS_SQLSERVER_FREE_SPACE
Free Space
QOS_SQLSERVER_LOCK_REQUESTS
*
QOS_SQLSERVER_LOCK_TIMEOUTS
*
QOS_SQLSERVER_LOCK_WAITS
*
QOS_SQLSERVER_LOGIN_COUNT
*
QOS_SQLSERVER_SERVER_CPU
Server CPU
QOS_SQLSERVER_SERVER_STARTUP
*
QOS_SQLSERVER_TRANSACTIONS
*
QOS_SQLSERVER_USER_CPU
User CPU
cdm
QOS_CPU_USAGE
*
QOS_PROC_QUEUE_LEN
*
processes
QOS_PROCESS_CPU
*
QOS_PROCESS_MEMORY
*
An asterisk (*) means that the value for the first entry for the QoS is used. The asterisk should only be used when the QoS metric for a probe is known to return only one value.
Database Performance
Column
Description
Host
Name of the host where the SQL server is installed.
Status
Monitors connectivity to the database instance. The different status are:
  • Connection Up = Green
  • Connection Down = Red
Buffer Cache Hit Ratio
Monitors the buffer cache-hit ratio. The different thresholds are:
0 to 50.99 = Red
51 to 74.99 = Orange
75 to 84.99 = Yellow
85 to 100 = Green
Uptime
Monitors the uptime (in days) of the database server.
Server CPU
Monitors CPU usage by the database in a monitoring interval.
FG Free Space with Available Disk
Column
Description
Host
Name of the host where the SQL server is installed.
FG Free Space with Available Disk
Monitors free space in filegroups after considering the available disk size. 
Free Space
Column
Description
Host
Name of the host where the SQL server is installed.
Free Space
Monitors free space in filegroups.
Locks
Column
Description
Host
Name of the host where the SQL server is installed.
Lock Waits
Monitors number of lock waits per second.
Lock Requests
Monitors number of lock requests per second.
Lock Timeouts
Monitors number of lock-timeouts per second. The different thresholds are:
0 to .79 = Green
.8 to .99 = Yellow
1 and greater = Red
Processes
Column
Description
Server
Name of the host where the SQL server is installed.
Process Name
Name of the SQL server process.
CPU
Percent of CPU consumed by the SQL server process in the last hour.
Memory
Number of kilobytes of memory consumed by the SQL server process in the last hour.
To monitor data in the Processes view, create a profile in the
processes
probe and configure it to monitor CPU and Memory QoS values.
Server Load
Column
Description
Host
Host name of the robot where the
cdm
probe is deployed.
Processor Queue Length 1 hr avg
Average load of the system in the last hour.
Current CPU Usage
Percentage of CPU used by the system. The different thresholds are:
  • 0 to 80 = Green
  • 80 to 90 = Orange
  • 90 to 100 = Red
Transactions
Column
Description
Host
Name of the host where the SQL server is installed.
Transactions
Monitors the number of transactions in the past hour.
User CPU
Column
Description
Host
Name of the host where the SQL server is installed.
User CPU
Monitors percentage of CPU Usage by user.
User Statistics
Column
Description
Host
Name of the host where the SQL server is installed.
Active Users
Monitors the number of active user per database.
Blocked Users
Monitors the number of users blocked.
Login Count
Monitors the number of users currently logged into the server.