18 minute readApplies to: v4

How to use the Performance tile

SquaredUp enables you to view a wide range of visualizations using performance data from the SCOM Data Warehouse. SquaredUp accesses the Data Warehouse directly using the published schema, so must have a Data Warehouse connection with the correct permissions for Performance graphs to work.

Overview

Performance tiles can be added to both dashboards and perspectives.

Performance Dashboard

This short (2 min) video gives you and overview of performance reporting features, including using the page timeframe, aggregation and resolution options, drilldown to a full page graph, compare to other objects/groups and export to Excel.

Performance tile types

After clicking on the Performance tile there are several performance graph types to choose from:

Performance Tile

Bar Top N

Bar Top N - uses the latest data to compare data, such as the top or bottom ranking metrics in descending or ascending order, as 'Top N'.

Bar Top N tile button

As these graphs use the latest data, they do not change when the user changes the page timeframe.

Heatmap

Heatmap - displays a performance metric as a colour shade, and can be configured to use an object property to determine the width of the rectangle. See the walkthrough below.

Heatmap tile button

Line Graph

Line Graph - This shows several objects, such as servers, on one graph with an x-axis (time) and a y-axis. See the walkthrough below.

Line Graph tile button

Sparklines

Sparklines - show individual server visualizations with maximum, minimums and current figures.

Sparklines tile button

Report

Report - this allows you to compare metrics, such as two different metrics or metrics over different time periods. For example, compare Processor Information % Processor Time with Memory Available MBytes, or compare Processor Information % Processor Time with the same period last week.

Report tile button

For a step by step guide to using this tile see the walkthrough below Adding a Report to compare metrics or time periods

The Performance drill down

Clicking on a line graph, bar chart or sparkline will take you to a Performance drill down page, shown below:

Performance Drilldown

From here you can:

Performance tile options

Metric

The quick find option will find metrics available, as you type, for the scope you have set. To see a list of all the metrics available, press the down arrow on your keyboard.

Performance Metric

Advanced allows you to specify the object, counter and/or instance. For example, you can use the quick find to find and select the metric LogicalDisk - % Free Space, and then click on advanced and specify C: in the instance box to only view C: drives.

Metric Instance

You can also use metric > advanced to show multiple metrics on one graph or use wildcards in metrics.

Resolution

SquaredUp uses the highest resolution data available (raw, hourly or daily), based on what data is available in the Data Warehouse for the whole graph time period.

The auto resolution setting (v4.3 and above) automatically changes the resolution to a more suitable resolution when the page timeframe is changed by a user, in order to optimise the time to return the graphs.

The data available in the Data Warehouse is determined by the retention period set in SCOM. When the retention period for hourly data is set to 180 days and a SquaredUp graph is set to display 6 months of data, this can actually be 182 or 183 days. SquaredUp will switch to daily data because hourly data is not available for the full 6 month period, i.e. the retention period is less than the date range. The solution is to modify the retention period to reflect 6 months i.e an extra 5 days and set the retention period to 185 days, this should not affect your storage levels too greatly. After a few days this will resolve the problem because 6 months of hourly data will then be available, when SquaredUp checks the retention period against the requested time frame, the retention period would be higher and SquaredUp would show hourly data.

Aggregate value type

When a resolution of hourly or daily is chosen you can select whether you'd like to see the average, minimum or maximum figures for that aggregated time period. For example, for a web transaction you might want to see the maximum or minimum figures rather than the average.

Timeframe

Dashboards and perspectives have a page timeframe option, which users can change by clicking the 12 hours button to change the default timeframe for the page from 12 hours to another time period. All tiles on the page which are set to use page timeframe will change to show data for the newly selected timeframe. Any tiles set to use specific timeframe will remain set to the timeframe specified when the tile was created.

timeframe

Data Range

The Data Range option allows you to choose the range of the y-axis or bar chart area. The min and max will be set, depending on the option selected

percentage shows 0 to 100

fit to data shows the data minimum to data maximum

fit to data (from zero) shows from 0 to the data maximum

custom fit allows you to specify the min and max

Sort - Top n

For bar charts and sparklines you can sort the order of the results either by the latest value or the label, in ascending or descending order.

Top n allows you to configure the number of results displayed by the tile and, using the ascending or descending options, determine whether these results will be selected from the top or bottom values for the chosen metric.

For bar charts and sparklines the top n option is only available when sort by value is selected.

When using top n with the time comparison on the Report tile see SquaredUp v4.3 and below: Why are the time comparison lines showing different objects to those shown on the legend?

Display

The height slider allows you stretch or shrink the graph height.

show legend allows you to display a key to the coloured graph lines, which is particularly important for Open Access dashboards when users are not able to click on the lines to drilldown.

Label

show legend allows you to display a key to the coloured graph lines, which is particularly important for Open Access dashboards when users are not able to click on the lines to drilldown.

The custom label section allows you to change from the automatic label to specify your own label format. For more information see How to use custom labelling.

Time comparison (Report tile)

This allows you to add a new dashed time comparison line to the graph showing the data as it was in the past.

Time Comparison SCOM

A time comparison line can be added to any layer, and will show as a dashed line. See Adding a Report to compare metrics or time periods

Time Comparison graph

If the page timeframe is changed by the user and it is no longer possible to show the time comparison line, then a yellow exclamation mark will be shown at the top right of the tile with a message. See Why is the time comparison line not shown?

See also Why is the time comparison line less detailed than the original line?

When using top n with the time comparison see SquaredUp v4.3 and below: Why are the time comparison lines showing different objects to those shown on the legend?

Walkthrough: Adding a Line Graph to show % Processor Time

The Performance tile can be used on a dashboard or a perspective. This walkthrough shows you how to add a Line Graph to a dashboard.

  1. In SquaredUp navigate to where you'd like the dashboard to be created. Hover over the + button and click dashboard.
  2. Give the dashboard a title, by replacing the text that says New Dashboard.

    The dashboard is saved as you go along so there's no need to save your changes. You can find your dashboard by clicking on the right-hand menu ☰ > system > unpublished.

  3. A new tile has already been added to the dashboard. Edit the title by overwriting the placeholder value New tile with your own title.
  4. The tile selector will already be open. Click Performance. The Performance tile button (along with several other tiles) displays a little plus up the top right. This indicates that there are more tiles available from this one button.

    Performance Tile

  5. Click on the Line Graph button to create a line graph.

    Performance (Line Graph) tile

  6. Next we need to scope the tile. In the scope section select group then type the name of a group, such as All Windows Computers or IIS Computer Group and then click on group from the results.

    Correctly scoping the tile is very important. To find out more about advanced scoping options see How to use criteria when scoping objects. On perspectives the tile scope will only show you the groups and classes that the object you have drilled down to is a member of.

  7. Click next.
  8. The quick find option will find metrics available for the scope you have set. Either start typing, or press the down arrow on the keyboard to see a list of all the metrics available. For this walkthrough type processor and then select the metric Processor Information - % Processor Time.

    Performance graphs for the servers should appear after a moment. You could stop here, but we'll continue to configure the tile.

  9. Click next.
  10. Leave the Timeframe set to use page timeframe so the timeframe for this tile changes when users change the page timeframe.
  11. Click next.
  12. In the top n section limit the number of results displayed to 3, and tick descending to show those with the highest processor utilisation.
  13. Leave data range as it is.
  14. In the display section drag the slider to increase the graph height, and tick show key.

    Line Graph Show Key

  15. Leave the label section as it is. For more information on changing the label see How to use custom labelling.
  16. Click done.

Walkthrough: Adding a Heatmap to show % Processor time and Logical Processors

  1. Click the orange + plus button to add a new tile to the dashboard.
  2. Click Performance, and then the Heatmap button.

    Heatmap

  3. In the scope section select group then type the name of a group, such as All Windows Computers or IIS Computer Group and then click on that group in the results. On perspectives the tile scope will only show you the groups and classes that the object you have drilled down to is a member of.
  4. In the metric quick find section type processor and then select the metric Processor Information - % Processor Time.

    A heatmap should appear after a moment.

  5. Once you've chosen a metric give the tile a title which explains what the tile shows.
  6. In the display section adjust the width and height sliders to change the heatmap sizes. In addition, you can choose to use a property to determine the size of each rectangle, for example logicalProcessors.

    Heatmap Property

    By default objects with no data are hidden, you can choose to show them by ticking the box show objects with no data.

  7. The colour section allows you to change the heatmap colour.
  8. Leave the data range section as it is for now. This allows you to change the range of values shown.
  9. Leave the label section as it is. For more information on changing the label see How to use custom labelling.
  10. Click done.

    Heatmap

Walkthrough: Adding a Report to compare different metrics and/or time periods

This walkthrough shows you how to add metrics as layers to the Report tile, and also how to compare them with historical data.

  1. Click on the Report button to create a Report.

    Report tile button

  2. Give the tile a title.
  3. The Report tile uses layers to allow you to add multiple metrics to one graph for comparison. This could get difficult to view in a narrow column, so this tile allows you to edit the tile full screen in a report editor). Click configure report to open the report editor and add layers.

    Report editor

    The report editor has opened full screen, but you can return to your dashboard at any time by clicking the back to dashboard button at the top right. The layer configuration appears on the left side of the screen, and a preview of the graph will show on the right as your proceed.

  4. The first layer is expanded ready for you to edit. Give the layer a title, such as the metric you intend to add.
  5. For this walkthrough we are going to compare two metrics for one machine. In the scope section click list then type the name of a machine, and then click on that machine in the results.
  6. In the metric > quick find box type the name of the first metric you want to add. For this walkthrough type processor and then select the metric Processor Information / % Processor Time.

    The right side of the screen will show a preview of the graph. You could stop here, but we'll continue to configure the tile.

  7. Click done.
  8. Click the orange plus button to add a second layer for your next metric.
  9. Give this layer the title of the metric you are adding.
  10. Click list then type the name of machine you used for the first layer, and then click on that machine in the results.
  11. In the metric > quick find box type the name of the first metric you want to add. For this walkthrough type memory and then select the metric Memory / PercentMemoryUsed.
  12. Leave the top n section as it is for this walkthrough.

    You might like to add a line to allow you to compare this data with historical data. Adding the time comparison is optional.

  13. In the time comparison section click one of the time periods to compare with this data, for example click yesterday.

    Time Comparison

  14. To add a time comparison for the existing layer, hover over the existing layer and then click the compare layer button to jump straight into the time comparison section and then click yesterday.

    Compare Layer Button

  15. In the y-axis section click on right to get the PercentMemoryUsed graph to use the right-hand y-axis. This is useful because the two metrics use quite different scales, so the two graphs show more clearly using two different y axes.
  16. Leave the label section as it is. For more information on changing the label see How to use custom labelling.
  17. At this point the graph is complete, so you can click done and then the back to dashboard button up the top right of the page.

    Report editor preview

  18. Return to editing the Report tile by clicking the edit this dashboard button at the top right, and then the edit tile button to the top right of the tile itself.
  19. Click into the legend configuration section and click on show legend to tick the box.
  20. Click done.

    Finished Report

FAQs

How do I show a metric that has a comma in the name?

Show How to use wildcards in metrics

How can I show more than one metric on the same graph?

For SquaredUp v4.3 and above use the Report tile, for v4.2 and below see How to show multiple metrics on one graph

What does the m µ k or M mean on the performance drilldown page? Why isn't GB shown?

See Understanding the figures on performance graphs

Why is the time comparison line not shown?

If a dashboard user changes the page timeframe then it may not be possible to show the time comparison line you have configured, so it may disappear from the report. For example, if you have chosen to compare to this time last week and the page timeframe is changed from the default setting of 12 hours to last 30 days or more then the time comparison line will be removed. To stop the comparision line being removed you can choose to fix the graph timeframe using timeframe > range, and update the tile title to point this out to users.

When the comparison line cannot be shown a yellow exclamation mark will be shown at the top right of the tile with a message similar to Timeframe from 5/25/2019 10:26:00 AM to 6/24/2019 10:26:00 AM cannot be shifted by the range 'Last7Days' because it is longer than the range.

Why is the time comparison line less detailed than the original line?

SquaredUp automatically uses the highest resolution data available for the time period. If for example you are comparing a weeks worth of data with this time last week, then last weeks data (days 8-14) will most likely being showing hourly data, because by default the retention settings only keep raw data in the Data Warehouse for 10 days.

Why are the time comparison lines showing different objects to those shown on the legend?

In SquaredUp v4.3 and below, when the top n option is applied to the Report tile using a time comparison, the top n lines are shown for the current time period, and the top n lines are shown for the time comparison period. This means that the lines shown for the time comparison may be for different objects to those shown for the current time period. Only the lines shown for the current time period are shown in the legend, which may not be clear when using Open Access. Dashed time comparison lines and normal lines are shown in the same colour if they refer to the same object.

In SquaredUp v4.4 and above the time comparison shows the same objects. So the top n is applied to select the objects for the current time period, and then the same objects are shown for the time comparison as dashed lines.

Troubleshooting Performance graphs

If no graphs are showing anywhere in SquaredUp, SquaredUp is particularly slow, or you are seeing connection or login failed errors on all Performance tiles, you should check the Data Warehouse connection, see Troubleshooting the Data Warehouse Connection

If you are seeing some graphs in SquaredUp, this means the Data Warehouse connection is configured correctly. If some Performance tiles show blank or show an error you should troubleshoot these tiles individually.

For example:

timeout-command: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

No values found for the given metric for the last 12 hours at the resolution 'raw/hourly/daily'.

See Troubleshooting the Performance tile

Troubleshooting the Performance tile

Troubleshooting the Data Warehouse Connection

How to use custom labelling

How to use criteria when scoping objects

How to export performance data to Excel

Understanding the figures on performance graphs

How to use wildcards in metrics

Squared Up Ltd. (c) 2020Report an issue with this article