⭐ Repository → 📁 Compliance Engine → 📁 CloudAware → 📁 AWS → 📁 Redshift

🛡️ AWS Redshift Cluster is underutilized🟢

• Contextual name: 🛡️ Cluster is underutilized🟢
• ID: /ce/ca/aws/redshift/cluster-underutilized
• Tags:
  • 🟢 Policy with categories
  • 🟢 Policy with type
  • 🟢 Production policy
• Policy Type: COMPLIANCE_POLICY
• Policy Categories: COST, PERFORMANCE

Logic

• 🧠 prod.logic.yaml🟢
  • 📗 AWS Redshift Cluster
  • 🔌 AWS Redshift Cluster - object.extracts.yaml
  • 🧪 test-data.json

Description

Open File

Description

This policy identifies AWS Redshift Clusters that are consistently operating with low CPU utilization and disk I/O over the last 30 days, which may indicate that they are oversized for their current workload. A cluster is flagged as underutilized if it meets the following conditions:

1. Average CPU utilization has been below 20%.
2. Average disk read IOPS has been under 50.
3. Average disk write IOPS has been under 50.

Rationale

Over-provisioning Redshift clusters results in unnecessary cloud costs. Identifying underutilized clusters enables you to make informed decisions about downsizing, leading to cost savings and ensuring that resources are better aligned with actual demand.

Impact

Resizing a cluster may require scheduling a maintenance window and could result in temporary downtime.

Audit

This policy evaluates an AWS Redshift Cluster based on its 30-day performance metrics.

The Cluster is marked as INCOMPLIANT if all the following criteria are met:

• CloudWatch: CPU, 30-Day metric is less than 20%.

... see more

Remediation

Open File

Remediation

From Command Line

Resize the Cluster

aws redshift resize-cluster \
    --cluster-identifier {{cluster-id}} \
    --node-type {{new-node-type}}
    --number-of-nodes {{new-number-of-nodes}}

You may specify either --node-type or --number-of-nodes, or provide both, depending on the resizing requirement.

policy.yaml

Open File

Linked Framework Sections

Section	Sub Sections	Internal Rules	Policies	Flags	Compliance
💼 Cloudaware Framework → 💼 Resource Right-Sizing			15		no data
💼 Cloudaware Framework → 💼 Workload Efficiency			24		no data