Analyze Current CPU Trend and Forecast Utilization

From the Aggregated Forecast View chart, you can view the current trend of CPU utilization, and use this trend to forecast your CPU utilization.

1. Under the section Trend/Forecast across databases, in the Filters field, enter the name of the database. You can specify up to five databases in the Filters field.

   Alternatively, in the CPU Breakdown by Individual Databases section, use Ctrl + Shift to select multiple databases. The data for the selected databases loads in the Trend and Forecast section.

2. To set the Regression Model, Forecast Period, and Confidence (%), click Settings.
3. Click Run.

   The information loads in the Trend/Forecast across databases section.

   For the Database Resource Analytics application to forecast your resource utilization for a year, there must be at least 13 months of data stored in the IT Analytics warehouse. The forecast resource utilization is more accurate when there’s more data stored in the IT Analytics warehouse.

You can plan your database capacity based on the current and forecast resource utilization.

Figure 3-2 Trend and Forecast Chart for CPU Utilization

Description of "Figure 3-2 Trend and Forecast Chart for CPU Utilization"

In the image, the forecast CPU utilization increases slowly over time. This means that at some point in the future, the CPU capacity will be entirely used. You should plan to expand the CPU resource capacity before that point, to ensure that your databases have enough resources to function smoothly.