MS SQL Overview
The MS SQL Overview is the top-level display for the MS SQL Monitor, which provides a good starting point for immediately getting the status of all your database instances and connections (on those instances) on your Data Server. You can select the RTView DataServer for which you want to see data and easily view the current data for that DataServer including:
| • | The total number of active alerts for the selected DataServer, including the total number of critical and warning alerts. |
| • | The number of database instances and the number of connections on those instances. |
| • | The maximum percentage of CPU utilization across all database instances. |
| • | The maximum percentage of memory utilization across all database instances. |
| • | A visual list of the top 10 active connections, connections with the best CPU utilization percentage, connections with the best used memory percentage, connections with the largest DB size, connections with the most received kilobytes, and connections with the most sent kilobytes on your connected DataServer. |
You can hover over each region in the upper half of the Overview to see more detail. You can also drill down to see even more detail by clicking on each respective region in the Overview. For example, clicking on the alerts in the CRITICAL and WARNING alerts region opens the Alerts Table by Components display.
The bottom half of the display provides a host resources trend graph for a selected database connection. You can hover over the trend graph to see the values at a particular time. You can specify the time range for the trend graph and view data based on a log scale, which enables visualization on a logarithmic scale and should be used when the range in your data is very broad.
