Viewing Cloud Optimization Reports - RDS

Viewing Cloud Optimization Reports - RDS

#380660

The results of Densify analyses are summarized in the various cloud service opportunity reports. Through these optimization reports Densify gives you the visibility to manage your workloads.

Cloud service opportunity reports are described in this topic for AWS RDS.

Details for the other tabs are provided in the following topics:

Note:  Instances without adequate data to perform the required analyses are not included in these reports.

The content of this tabular report is described in the following table:

Component / Column Name

Description

Count

The number of instances listed in this column is a hyperlink that takes you to the Instance Optimization Details page for the selected group. For more information, see Understanding the Instance Optimization Details for RDS.

Overall Status

Identifies the overall status of the optimization results based on the Optimization Type and potential $ Savings/Month :

Optimal

These instance types are currently sized correctly and there are no costs savings for this group of systems.

Identified Risk

These instance types are at risk. This status occurs when the savings amount is less than $0 (i.e. you need to spend money to mitigate risk).

Identified Risk status is also indicated when the savings amount is $0, but optimization type is upscale, upsize, or upsize to optimal family. This situation occurs when services are inactive, however, they will need to be upscaled or upsized to mitigate risk when they resume activity.

Savings Opportunity

These instance types can provide saving opportunities that greater than $0.

Savings opportunity status is also indicated when the savings amount is $0, but optimization type is terminate, modernize, modernize to optimal family, downscale, downsize, or downsize to optimal family. This situation occurs when services are inactive, but have a recommendation of terminate, modernize, downsize or downscale when they resume activity to save money.

Optimization Type

The recommended type for the group of instances. See Optimization Type Descriptions and Color-Coding.

Current Instance Type

The current catalog instance is listed. This value is based on the data collected.

Recommended Instance Type

This is the recommended catalog instance, based on optimization analysis.

Recommended Purchasing Strategy

This column is no longer used.

Defer Recommendation Until Current RI Coverage Expires

Defer recommendations until reserved instance coverage for this group expires. Values include:

  • Yes—defer recommendations due to RI coverage;
  • No—do not defer recommendations; this is also the case for "Terminate" recommendations;
  • "-" —not applicable; no change is listed for "Just Right" recommendations.

This field is based on AWS Defer Recommendation settings. Contact [email protected] to review your AWS Defer Recommendation settings.

Current RI Expiry Date

RI data is no longer collected and this column is no longer in use.

Current Estimated Cost ($)

The current estimated cost is determined by adding all the current estimated cost of each instance in the group. See Current Estimated Cost ($) in the Instance Optimization Details report.

Recommended Estimated Cost ($)

The recommended estimated cost is calculated by adding all the recommended estimated cost of each instance in the group. See Recommended Estimated Cost ($) in the Instance Optimization Details report.

$ Savings/Month

The estimated current and recommended instance cost is used to calculate savings per month (i.e. current estimated cost - recommended estimated cost).

Effort

[ High | Medium | Low | None ]

This column describes the effort required to investigate and implement the Densify recommendations. The displayed group effort is an average of all the calculated efforts for each instance (or service) in the group. Effort for each instance is calculated by rule-driven analytics based on factors (such as family change, storage change, data quality checks, feature changes, etc.) that can be configured in the policy settings and rule set which captures best practices.

Current vCPUs

The current value for CPU allocation.

Recommended vCPUs

The recommended value for CPU allocation.

Current Memory Allocation (GB)

The current value for memory allocation.

Recommended Memory Allocation (GB)

The recommended value for memory allocation.

Footnote

A footnote at the bottom of the optimization opportunity report displays the total number of instances (subject to any guest filters applied) of the specific public cloud service type. The number of instances is a link to the Instance Optimization Details page, showing an aggregate report that contains all recommendations of that service type in one view. For details on this page, see Understanding the Instance Optimization Details for RDS.

Note: If recommendation filters are applied, the total number of instances on the last page of the optimization report might not be the same as the total number of instances in the footnote; this is because the recommendation filters are not reflected in the footnote total.

Sort By

You can change the instance group order of the tabular optimization opportunity report by selecting one of the sort options in the top Sort By dropdown list. For details on sorting behavior, see Sorting Options.

Note: If there is no data in the optimization opportunity tabular report, the Sort By section is not displayed.

Summary Total

In the top-right corner of tabular optimization opportunity reports, the total number of Instances and the Savings/Month for implementing the recommendations are displayed. The total number of instances displayed is a total of all the analyzed instances with guest and recommendation filters applied. The amount of savings per month is based on filtered data and can be negative if there is higher upsizing cost.

Note: If there is no data in the optimization opportunity tabular report, the Summary Total section is not displayed.

Filtering Options

You can filter the optimization opportunity reports by guests and instance attributes, as well as by recommendations.

Note:  The global filter is not applicable to the cloud optimization opportunities dashboards and is not accessible on these pages.

Filtering by Guest Attributes

You can filter instances using a set of attributes (e.g. Business Unit, Application).

This type of filtering is supported on the optimization opportunities dashboard tabs, as well as the Instance Optimization Details page when navigating from the Count column. The guest filters selected are persistent across platforms for those pages that support the guest filters (i.e. guest filters selected for AWS EC2 will apply to the AWS RDS, as well as the AWS Instance Optimization Details reports).

For details, see Using the Guest Filter.

Filtering by Recommendation

You can filter instances based on recommendations using the Recommendation Filter Menu. This filter allows you to narrow the results of your optimization reports based on recommended optimization type, effort required, monetary impact, and service characteristics. The resulting filtered report can be exported for external analysis using the Export to Excel () tool.

For details, see Using the Recommendation Filter Menu.

Sorting Options

Optimization opportunity reports in tabular format can be sorted by the following fields:

  • Overall Status & Optimization Type (default option)
  • $ Savings/Month High to Low
  • $ Savings/Month Low to High
  • Effort None to Moderate
  • Effort Moderate to None
  • Current RI Expiry Date

Guest systems are sorted based on the selected sort option with any guest or recommendation filter already applied to the displayed results. The sorted report can be exported (in the same sort order) for external analysis using the Export to Excel tool.

The selected sort option is saved within the same session and will also be applied when you navigate to another tabular optimization opportunity report within the same public cloud environment supporting the sort option. For example, if you specify that the sort option is Effort High to None in the AWS EC2 optimization opportunity report, then when you navigate to the AWS RDS optimization opportunity report, the sort option still remains Effort High to None. However, if you navigate to the Azure Virtual Machines optimization opportunity report, the sort option will change to the default or saved Azure sort option. When you logout of Densify, the sort option is reset to default sorting.

Sort Options

Description

Overall Status & Optimization Type

(default)

By default, the tabular optimization opportunity reports are ordered based on this option. Instances are first sorted by Overall Status , in the following order:

  1. Savings Opportunity
  2. Optimal
  3. Identified Risk

If the overall status is the same, then the secondary sort key is Optimization Type , in the following order:

  1. Terminate
  2. Modernize
  3. Modernize - Optimal Family
  4. Downsize
  5. Downsize - Optimal Family
  6. Just Right
  7. Upsize
  8. Upsize - Optimal Family

If overall status and optimization types are the same for the instances, then the tertiary sort key is by instance Count , in descending order.

$ Savings/Month High to Low

Sort by the $ Savings/Month field, from largest savings to lowest savings. If the savings are the same, then secondary sort is performed on Effort , from None to High.

$ Savings/Month Low to High

Sort by the $ Savings/Month field, from lowest savings to largest savings. If the savings are the same, then secondary sort is performed on Effort , from None to High.

Effort None to High

Sort by Effort , from None to High. If the effort is the same, then secondary sort is performed on $ Savings/Month , from largest savings to lowest savings.

Effort High to None

Sort by Effort , from High to None. If the effort is the same, then secondary sort is performed on $ Savings/Month , from largest savings to lowest savings.

Current RI Expiry Date

Sort from earliest to latest date. Instance groups with no RI expiry dates are displayed at the end of the list.