🛡️ Azure PostgreSQL Server is underutilized🟢

• Contextual name: 🛡️ Server is underutilized🟢
• ID: /ce/ca/azure/postgresql-database/server-underutilized
• Tags:
  • 🟢 Policy with categories
  • 🟢 Policy with type
  • 🟢 Production policy
• Policy Type: COMPLIANCE_POLICY
• Policy Categories: COST, PERFORMANCE

Logic

• 🧠 prod.logic.yaml🟢
  • 📗 Azure PostgreSQL Server
  • 🔌 Azure PostgreSQL Server - object.extracts.yaml
  • 🧪 test-data.json

Description

Open File

Description

This policy identifies Azure PostgreSQL Servers that are potentially underutilized based on their performance metrics over the past 30 days. Underutilized servers are often provisioned at a higher tier than required, resulting in unnecessary cloud costs. A server is flagged as underutilized if its average CPU and I/O utilization are all below 20% and memory is below 40%.

Rationale

Over-provisioned servers increase expenses without delivering corresponding benefits. By identifying and rightsizing underutilized PostgreSQL servers, organizations can reduce costs and improve overall resource efficiency.

Impact

Carefully review to confirm that the new configuration will accommodate peak demand. Note that resizing a server triggers a brief period of downtime while the change is applied.

Audit

This policy evaluates an Azure Azure PostgreSQL Server based on its 30-day performance metrics.

The Server is marked as INCOMPLIANT if:

• Monitor: CPU Percent, 30-Day < 20%.

  and Monitor: IO Consumption Percent, 30-Day < 20%.

... see more

Remediation

Open File

Remediation

Resize the Server

Before resizing, review workload trends to ensure the new configuration can support peak demand.

From Azure CLI

az postgres server update \
    --resource-group {{resource-group}} \
    --name {{server-name}} \
    --sku-name {{new-sku-name}}

From PowerShell

Update-AzPostgreSqlServer `
    -ResourceGroupName {{resource-group}} `
    -Name {{server-name}} `
    -Sku {{new-sku-name}} 

Note: Resizing triggers a restart of the PostgreSQL server, causing a short period of downtime.

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