Analyze Database Memory Usage

View the current memory utilization trend, compare the memory utilization across databases, and forecast future memory resource needs to plan your resources for a later time period.

Analyze Available Memory Resources

The Memory section under the Overview tab displays the available memory capacity and the current utilization.

Alternatively, click the Memory tab in the left pane. The first chart (Aggregated Forecast View) shows you the database memory usage and the available memory resources.

Figure - Aggregate Forecast Chart for Memory Usage

Description of "Figure - Aggregate Forecast Chart for Memory Usage"

The difference between the values for Used Memory and Available Memory is the unused capacity. The smaller the difference between your actual resource usage and your resource capacity, the more urgent the need to expand your available resource capacity.

Compare Memory Utilization Between Databases

The Memory breakdown by individual databases chart lets you compare how your different, individual databases are using their resources.

1. Click the Group by list to select what metrics to group the databases by.

   • Life Cycle Status

   • Target Version

   • Cost Center

   • Host Name

   • Contact

   • Database Type

2. To view the 10 databases consuming the most memory resources, from the Group By list, select Top 10.
3. Select the databases for which you want to view specific information.
4. To view the list of databases, and their relevant information like the DB type, memory used, change %, hostname, target version, life cycle, and cost center in a CSV format, click Download CSV.

The amount of memory resources and the percentage change in the usage of memory resources are represented visually, through the size and color of the cells, respectively. The cells that are larger in size use more memory resources than the smaller cells. The largest cell would be that of the database using the most memory resources. The color of the cells is determined by the percentage change in the memory resources used by the databases.

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.