9 minute readApplies to: v4

How to use the Performance tile

Squared Up enables you to view a wide range of visualizations using performance data from the SCOM Data Warehouse. Squared Up 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.

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

Performance Dashboard

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

  • Bar Charts - show comparable data, such as the top or bottom ranking metrics in descending or ascending order, as 'Top N'.

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

  • Heatmap - displays two items of data: a performance metric which is shown as colour, and an object property which is shown by the size of the rectangle.

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

Squared Up 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 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 Squared Up graph is set to display 6 months of data, this can actually be 182 or 183 days. Squared Up 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 Squared Up checks the retention period against the requested time frame, the retention period would be higher and Squared Up would show hourly data.

Aggregate value type

When a resolution of hourly or daily is chosen you can choose 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

Display

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

show key 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

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

Top N

For bar charts you can limit the number of results to the top few by specifying a number in the top n section.

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 Performance line graph to a dashboard.

  1. In Squared Up 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 Performance (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

  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. Leave Data range as it is.

  13. In the display section drag the slider to increase the graph height, and tick show key.

    Line Graph Show Key

  14. Leave the label section as it is. For more information on changing the label see How to use custom labeling.

  15. 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 Performance (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 group from the results.

  4. Click next.

  5. In the metric quick find section type processor and then select the metric Processor Information - % Processor Time.

    A heatmap should appear after a moment.

  6. Click next.

  7. In the display section you need to select a suitable property to determine the size of each rectangle. From the property dropdown box select properties.logicalProcessors.

    Heatmap Property

  8. Adjust the width and height sliders as required.

  9. Click next.

  10. The colour section allows you to choose your own colour.

  11. Click done.

    Heatmap

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?

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

Troubleshooting Performance graphs

If no data is shown, try increasing the timeframe. When hourly data is chosen, a 1 hour timeframe will not show any data.

If you see an error where you should see Performance Graphs, you should check the Data Warehouse connection, see Troubleshooting the Data Warehouse Connection

How to use custom labeling

How to use criteria when scoping objects

How to export performance data to Excel

Understanding the figures on performance graphs

How to show multiple metrics on one graph

How to use wildcards in metrics

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