Understanding the Instance Optimization Details for RDS

Understanding the Instance Optimization Details for RDS

#380870

The Instance Optimization Details report displays instance-specific details for RDS instance types.

Open the Instance Optimization Details report, by clicking on a hyperlinked value in the Count column from the RDS optimization opportunity tabular report.

Instance optimization details for the other tabs are provided in the following topics:

Note:  Cloud instances that do not have adequate information for recommendation analysis are not included in the Instance Optimization Details report. For example, this would include guests with no data or incomplete benchmark data.

Page Navigation

Use the breadcrumbs in the upper left corner or click the Back button, in the top-right corner of the page, to return to the parent dashboard. Do not use the browser's Back button for navigation within Densify. You will be logged out of your session. See Navigating Densify for other features of the Densify user interface.

The Instance Optimization Details dashboard consists of:

  • A tabular report—The columns of the tabular report change depending on the selected instance type. Refer to the Table: Instance Optimization Details Tabular Report Columns below for details.
  • A lower pane with system details—Based on the selected system in the tabular top pane, various details and settings for the system are available in separate tabs, such as system resource utilization charts, system details, optimization approvals and modifying system attributes. See Reviewing Specific Instance Details for details on each tab.

Reviewing the Instance Optimization Details Table

Tabular Report

  • The columns of the tabular report change depending on the selected instance type. See the table below for details.
  • Note:  The following details are not included in this report: Disk Allocations (Current | Recommended), Individual Disk Partitions at Risk, Disk Usage and Parent.

    Optimization Type Descriptions and Color-Coding

    The following descriptions and color coding apply to all AWS, Azure and GCP tabs.

    Note:  Not all optimization types are supported for all cloud providers.

    Reviewing Specific Instance Details

    Clicking on any row in the tabular report shows more detailed system information for that instance, in the tabs on the lower pane:

    • Metrics Viewer—The link on the left side of the lower pane, opens the metrics viewer. You can use the metrics viewer to investigate details when deciding whether to action specific recommendations. See Using the Metrics Viewer.
    • Catalog Map—This link opens the Analysis Details page showing the chart displaying the available recommendation options for the selected instance. See Using the Catalog Map for details.
    • Analysis Report—This link opens Impact Analysis and Recommendation Report report. See Viewing the Public Cloud Impact Analysis and Recommendation Report
    • Analysis Report—This link opens Impact Analysis and Recommendation Report report. See Viewing the Public Cloud Impact Analysis and Recommendation Report
    • Resource Utilization Metrics: Cloud Tab—The charts on this tab show the utilization for various workloads for the selected the instance.
    • Note:  If no metrics are available, then the corresponding chart is not displayed.

      If a cloud instance has been optimized (i.e. instance type has been changed based on a recommendation), then on the next day you will see the Optimization Type set to "Just Right" and since the required data (as defined by the policy) has not been accumulated, only the Memory BackFill workload chart is displayed, if enabled. See the column, Instance Type Updated On , in Table: Instance Optimization Details Tabular Report Columns, above for more details.

      These workload charts show hourly min/max and sustained activity for the selected system. Use the left/right arrows to scroll though the various workload charts.

      Workload charts show current Sustained Activity in blue, while Sustained Activity on the recommended instance type is shown in green.

      Note:  The recommended instance type (green) is not applicable and so is not shown for Optimal and Terminate recommendations.

      The minimum and maximum utilization values are shown as vertical lines above and below the coloured block. The median is indicated as a black line within the coloured block. The average is indicated in brackets, in the sub-title of the chart.

      The scale used on the Y-axis is scaled dynamically to match the range of data. Where applicable, the pink line indicating the policy high limit, is shown, and the setting of the Y-axis scale also accounts for the policy limit setting. This is applicable to both public cloud and virtual optimization charts for Resource Utilization Metrics.

    • System Information Tab—Click on this tab to see allocated resources and some of the organizational attributes that have been set for this guest.
    • Effort Details Tab—This tab lists the factors that contribute to the effort required to investigate and implement the Densify recommendations. Effort for each instance is calculated by rule-driven analytics based on factors (such as instance family change, storage change, data quality checks, feature changes, etc.) that can be configured in the policy settings and through analysis rule sets. A description of each rule/property and its impact on the effort to move the current instance to the recommended instance type are provided.
    • Contact [email protected] for further details on the policy settings and rule set configured for your environment.

    • Predicted Uptime Details Tab—This tab shows a pie chart with the uptime details for the selected instance.
    • Approvals Tab—This tab is no longer in use and will be removed in a future release.
    • Edit System Attributes Tab——This tab is no longer in use and will be removed in a future release.

    Quartiles in the Resource Utilization Charts

    In charts, workload data for each system is shown in four different bars (two yellow and two red), called quartiles, to show minimum, average, sustained and peak values. When used in the analysis, quartiles provide a good representation of system activity because the weighted scoring for sustained and peak activity produces a more accurate assessment of workload utilization patterns and requirements.

    Quartiles are calculated in the following manner:

    • Workload activity is collected every five minutes, which totals 12 times per hour.
    • The 12 values are then re-ordered in descending order and separated into equal sample sizes (quartiles), with each quartile having three values. Each quartile represents 25% of operational time.
    • The bottom of the first quartile shows the minimum value, the next quartile shows average values, the top of the third quartile shows the sustained value and the top of the fourth quartile shows the peak value.

    Editing System Attributes

    The Edit System Attributes tab in the lower pane of the Instance Optimization Details report allows you to edit specific attributes of the system selected from the top pane.

    This feature is also supported via the Densify API. Refer to the API documentation.

    The following default system attribute categories are available for editing:

    • Business

    Contact [email protected] if you require additional system attributes to be exposed for editing.

    Attribute changes are displayed accordingly in the Edit Systems Attributes tab.

    Densify optimization and reporting database updates are required before the saved values are reflected in the Instance Optimization Details tabular report and footer. For example, if you update and save one of the Self-Optimizing Automation Overrides attributes, you can see the updated value in the Edit Systems Attributes tab and extract the updated attribute value from the Densify API. However, the Instance Optimization Details tabular report and footer will not display the recommendation results of the updated value until analysis has been performed and the reporting tables have been updated via the overnight scheduled job.