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 - follows Description of Figure - follows](img/dra-aggregate-forecast-view-memory.png)
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.
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.
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.