Walkthrough 4: Working with analysis and reporting
In this walkthrough, we'll use SQL Monitor's Analysis tab. In the Analysis tab, we can view the graphs and figures for the performance data SQL Monitor has gathered.
When we click on the tab, we are initially presented with a list of metrics on the left, grouped by the monitoring level to which they apply. When we select a metric, SQL Monitor will open submenus, where we can specify machines, SQL Server instances, and so on.
In this example, we've selected Batch requests/sec, a metric that applies to the SQL Server level. This means we need to specify the machine and SQL Server instances we're interested in. Accordingly, a submenu with all our monitored machines appears. We'll select homer.testnet.
This opens a menu for the final sub-level, the SQL Server instance. We can look at individual instances, or all of them together. We'll look at them all.
Once we've selected all the relevant subsections, the data appears in the graph box below. On the right hand side, we have a built-in description, which provides details about the metric, and statistics, under the Statistics tab.
Under Statistics, we have the mean, maximum and minimum values of our metric for the time period we're looking at. If we want to check the figure at any particular point, we just hover over that point in the graph.
To change the time period we're looking at, we use the Time range drop down menu. There are several pre-configured time periods, or we can specify times and dates, and even go back in time.
In the same menu, we can choose pre-configured time periods to compare against each other. They display on the same graph for easy comparison, and our Statistics tab is updated to include both.
We can also export any of this data in .csv format, by clicking the Export button, to the left of the Time range drop down menu.
exc. support & upgrades10 licences
exc. support & upgrades
Try a 14-day fully functional free trial of SQL Monitor.
Find out more: