5.1 Chart Viewer

Charts provide a graphical representation of workload and utilization data. To view a chart for a given server, select the server in the Data Center Explorer or click a cell belonging to the server in a report view. You can also select several servers in the Data Center Explorer (hold down Ctrl or Shift while you select the servers) to render charts for multiple servers. In this case, a chart is not automatically rendered, but a Create Chart button is displayed in the Chart Viewer. Click Create Chart to render the chart.

Review the following sections to work with charts:

All times displayed in the Chart Viewer are local times. Times shown in reports are in UTC time.

5.1.1 Chart Controls and Commands

Figure 5-1 Chart Controls

Table 5-1 Chart Viewer Commands

Command

Description

Print Preview icon

Print Preview. Preview chart before printing.

Print icon

Print. Print the chart.

Copy To Clipboard icon

Copy To Clipboard. Copy the chart to the clipboard.

Line icon

Line. Display straight lines between points of continuous data.

Curve icon

Curve. Display curved lines between points of continuous data.

Candlestick icon

Candlestick. View the variability of sample data. This button appears only for the candle chart.

Stacked Bar icon

Stacked Bar. View cumulative workload data from multiple servers. This is enabled for Expression types other than Utilization.

Stacked Area icon

Stacked Area. View cumulative workload data from multiple servers. This is enabled for Expression types other than Utilization.

Legend Box

Legend Box. Give a visual cue and description for each data object. The legend is very useful for quickly glancing through the data on a chart.

Point Labels icon

Point Labels. Display labels for the values in a chart.

Zoom icon

Zoom. Switch between normal and magnified view.

Zoom In/Out iconsZoom In/Out icons

Zoom In/Out. Adjust the granularity of the chart for the collected data. See Section 5.1.3, Level of Detail.

Navigate Beginning/Back/Forward/End icon

Navigate Beginning/Back/Forward/End. Scroll the visible data.

Historical Data Settings icon

Historical Data Settings. Select the historical data time range upon which to base forecasting.

Forecast Settings icon

Forecast Settings. Select the forecasting time period and algorithm.

This button is only enabled for daily or weekly Series charts or for Profile charts.

Refresh All Data From Server icon

Refresh All Data From Server. Refresh the view.

5.1.2 Expression Types

Expressions are individual data series that can be viewed on the currently displayed chart. Select an available Type/Expression combination and the chart is rendered to display the new metrics. The list of available expressions varies depending on the expression type and machine selected.

Table 5-2 Expression types

Type

Expressions Available

Description

Workload

For a complete list of expressions available for Workload, see Section B.4.3, Workload.

The operating system, applications, and data stack running on a server, with the quantified dimensions of Processor Speed, Memory, Disk Space, Network, and Time.

Utilization

For a complete list of expressions available for Utilization, see Section B.4.2, Utilization.

Characterizes the fit between workload and resources (% utilization).

Counter

Counter values are named for the Windows Performance Monitor counters used to retrieve them from Windows systems. The name consists of the Performance Monitor category joined by an underscore to the counter name. For example, Memory/PagesPerSecond becomes Memory_PagesPerSecond.

For a complete list of the available counters, see Platform Counters.

Primitive measure of performance collected from the operating system.

5.1.3 Level of Detail

From the drop-down list, select from the following levels of granularity (in terms of time) for collected data:

  • 5 Min: Averages of data collected during five-minute intervals. (Series charts only.)

  • 1 Hour: Summaries of data collected during one-hour intervals. (Series and Candle charts only.)

  • 1 Day: Characterizes workloads over a day. This comprises 24 values that correspond to each hour of the day (0 to 23). Each value is calculated by taking the peak value from all values observed for that hour. (All chart types.)

  • 1 Week: Characterizes workloads over a week. (All chart types.)

5.1.4 Data Type Statistics

The following data type statistics are collected for each hour and are available for selection when a 1 hour or higher zoom level is selected: This option is available only for series charts.

  • AVG: Average of all values.

  • MAX: Maximum sustained load.

  • MIN: Minimum sustained load.

  • STDEV: Standard deviation.

    NOTE:Standard deviation is not calculated for Virtual Center counters.

  • Peak AVG: : (1 Day or 1 Week only) Peak average represents the averages of the values for the highest period for each 12-hour interval or each day in the reporting period.

5.1.5 Server Instance

Click the drop-down list to see all the instances of the currently selected resource (expression). Select each instance to see chart data for that resource. If multiple servers were used to render the chart, all instances of the resources for all servers are displayed. The instances are displayed as legends in the Series and Profile charts, and in the drop-down list located in the tool bar for candle charts.

5.1.6 Date Range Presets

Select from the drop-down list Last 3 days, Last 7 days, Last Month, or All Data. Select <Custom> to open the Advanced Date Filter Settings dialog box for more specific date range options.

5.1.7 Forecasting

Forecasting is available for series and profile charts, for the 1 day and 1 week level of detail. At least three days of monitoring data are necessary to use forecasting in charts.

To add forecasting to a chart view:

  1. Display a Profile chart.

  2. Click the Date Range drop-down list and select a time period to base the forecast on.

  3. (Optional) Click Historical Data Settings Historical Data Setting icon for advanced date filter settings.

    The Advanced Date Filter Settings dialog box is displayed. Choose any desired settings and click OK.

  4. Click the Forecast Period drop-down list and select a time period for the forecast.

  5. (Optional) Click Forecast Settings Forecast Settings icon for advanced custom forecast settings.

    The Advanced Forecast Settings dialog box is displayed. Choose any desired settings and click OK.

  6. Click the Forecast > Trend drop-down list and select a forecast trend or regression method.