Database Capacity Planning

Use the Capacity Planning/Database menu item to access a summary of database CPU, Storage, Memory, and I/O utilization across the selected compartment.

From the Database Capacity Planning Summary page, you can view current database resource utilization by CPU, storage, memory, and I/O . You can also compare and contrast resource usage between databases, and identify which databases use the most resources, and are expanding rapidly.


Image shows the Capacity Planning Summary page.

This page directly supports the goals of providing a birds-eye view of database resource usage and trends, and providing proactive insights into specific utilization issues either current or forecast for the near-term.

From this page you can perform the following tasks in support of the Capacity Planning use case goals:
Note

Capacity Planning color scheme associates green with CPU resources and blue with Storage resources.
  • View total allocation and utilization of CPU, Storage, Memory, and I/O resources for all (enabled) databases in the compartment
  • Identify top-5 databases of CPU, Storage, and Memory by absolute usage or utilization percentage
  • Identify top-5 databases by CPU, Storage, and Memory growth over the time period
  • See aggregated historical usage trends for CPU, Storage, and Memory over the time period
To further personalize service configurations, including creating custom tag filters, see: Service Configurations.
Note

A Collection Issues widget will appear under Databases if there are any database resources experiencing collection issues. Click on the widget to navigate to the database Collection Issues dashboard.

The Inventory section displays the total number of databases enabled for Ops Insights along with the database types. In addition, the CPU, Storage, Memory, and I/O usage charts display overall resource consumption (Top Consumers and Usage Trend) by these database targets.

The section shows the current utilization of databases and the databases that are reaching the server capacity headroom.

CPU Insights, Storage Insights, and Memory Insights.

These sections show the number of databases running with low (0–25%) and high (75–100%) utilization of resources. For CPU utilization, it is the utilization percentage for the 90th percentile value of the daily average CPU usage over the selected time period. That is, if the 90th percentile value of CPU usage is associated with utilization above the 75% threshold, then the database is considered high CPU utilization.

For Storage and Memory utilization, it is the databases forecast to reach high utilization (>75%) or maintain low utilization (<25%) within the 0-30 day time period. Forecast training data are based on the selected historical data time period.

You can drill down to view the CPU, Storage or Memory breakdown for either individual databases or for an aggregated view of all databases.

Changing Utilization Thresholds

By default, Ops Insights sets the high and low utilization thresholds at 75% and 25%, respectively, for CPU, Storage, and Memory Insights. Customizing these forecast metric thresholds provides more granular capacity management forecasting, thus allowing you to be more proactive in resource management by setting threshold values that are more relevant to a specific target type for more accurate forecasting.

To change a utilization threshold:

  1. Navigate to the Capacity Planning page.
  2. For any of the Insights, click the information icon (i) next to the right of Utilization. These information icons are metric specific (i.e. if you launch from CPU Insights this modifies CPU-specific configurations), click on the icon specific to what threshold type you wish to modify. A descriptive pop-up dialog displays.
    Image shows the custom threshold pop-up.

  3. Click Edit Configuration. The Edit Configuration dialog displays.
  4. Enter new alert threshold percentages under User interface settings for:
    • High Threshold
    • Low Threshold
    Enter new Alert metric settings for:
    • Forecast algorithm: Seasonally aware, Linear, or AutoML
    • Metric value: Average, or Maximum
    Note

    If you wish to reset any value to its default, click on Reset to default
  5. Click Apply. Custom utilization thresholds apply to the current compartment.

Once applied, all Ops Insights statistics and forecast queries relying on these utilization thresholds will be updated to reflect the new threshold settings. For example, navigate to the CPU Insights. On the Aggregate tab, select Utilization Level from the Grouping drop-down menu. The aggregation chart, as well as Trend & Forecast chart, will reflect the new custom thresholds.