Displaying metrics on the analysis graph
Published 25 July 2013
This page applies to SQL Monitor 3.3 and later. For earlier version of SQL Monitor, see Working with metrics in SQL Monitor 3.2 and earlier.
You can display multiple metrics in the analysis graph simultaneously. This can help show whether the performance of one metric has an impact on others, and identify performance correlations over time.
To do this:
- Choose the performance metric you want to plot from the Show list. Metrics are grouped into Machine, SQL Server, Database and Custom metric categories.
Select the object to plot from the For list.
For some types of metric, you can plot all the objects together. This example below shows Machine: processor time selected for one of the machines in a cluster:
To display another metric on the same graph, click Add another metric.
By default, the next metric in the list is selected. The For lists display (As above) to confirm they're using the same objects as the metric previously selected, but you can choose a different metric or object. In this example, we've added Avg. CPU queue length for the same machine in the cluster as the Machine: processor time metric:
A color-coded key to the metrics is displayed to the right of the graph:
- Repeat step three until you've displayed every metric you're interested in.
To edit an existing metric selection, click on the Show or For text box to automatically expand the drop-down lists, or click the Expand buttonat the end of the row.
To remove a metric from the graph, click the Remove metric buttonat the end of the row.
To display the Edit custom metric wizard for a selected custom metric, click the Edit custom metric Editing a custom metric.button at the end of the row. For more details, see
Changing the time range
By default, the graph displays data for the last hour. To change the time range:
Use the time controls above the graph: the drop-down menu, the date/time pickers, and the paging buttons. You can also use the quick links below these controls to select a time range immediately before the present time.
You can also:
- zoom in and out using the mouse wheel
- click and drag the graph left and right
- pan around using the panning arrows on the left and right of the graph
Zooming with the mouse, and clicking and dragging, are not available in IE7 and 8.
Select a different fixed value from the Time range drop-down list.
To specify a particular time range, click the Set custom time range iconand enter the start and end time.
Viewing values on the graph
Each graph line represents the performance of a selected object. SQL Monitor plots up to a maximum of 500 data points on each graph and draws straight lines between consecutive points. For short time ranges (less than 10 minutes) the graph displays fewer data points. For longer time ranges (greater than 45 minutes), data is aggregated to make sure that whatever the time range displayed, peaks and troughs are maintained on the graph relative to each other so you don't miss anything important.
Move your mouse pointer over a line on the graph to view a tooltip showing the time, metric, object and value at that data point.
If you're comparing data for different time ranges, the line for the older time range is displayed in a lighter shade.