SQL Monitor 11

Displaying metrics on the analysis graph

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:

  1. Choose the performance metric you want to plot from the Show list. Metrics are grouped into Machine, SQL Server, Database and Custom metric categories.
  2. Select the object to plot from the For list.

    For some types of metric, you can plot all the objects together. The example below shows Machine: processor time selected for one of the machines in a cluster:

  3. 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:


  4. Repeat Step 3 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 button at the end of the row.

To remove a metric from the graph, click the Remove metric button at the end of the row.

To display the Edit custom metric wizard for a selected custom metric, click the Edit custom metric button at the end of the row. For more details, seeEditing custom metrics and alerts.

Changing the time range

By default, the graph displays data for the last hour. You can change the time range using 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.

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.

Do you have any feedback on this documentation?

Let us know at sqlmonitorfeedback@red-gate.com

Didn't find what you were looking for?