Analyze Current Memory Usage Trend and Forecast Utilization

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

1. In 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 Memory breakdown by individual databases section, use Ctrl + Shift to select multiple databases.

   The data for the selected databases loads in the Trend/Forecast across databases 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.