Performance monitoring, alerting, and diagnosis for SQL Server

Walkthrough 4: Working with analysis and reporting

SQL Monitor Analysis tab

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.

SQL Monitor Analysis tab, choosing a machine

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.

SQL Monitor Analysis tab, choosing a SQL Server instance

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.

SQL Monitor Analysis tab with statistics

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.

SQL Monitor Analysis tab time range drop down menu

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.

SQL Monitor Analysis tab, comparison

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.

Pricing $1,495

10 licences $7,475

SQL Monitor is licensed and priced per server, with volume discounts available.

Got a question?
Download

Try a 14-day fully functional free trial of SQL Monitor.

SQL DBA Bundle
SQL DBA BundleSeven essential tools for database administration.


Contains:

Find out more:

Awards
Silver Community Choice Best Database Monitoring and Performance Product