⭐ Repository → 📁 Compliance Engine → 📁 CloudAware → 📁 Azure → 📁 SQL Database

🛡️ Azure SQL Elastic Pool is underutilized🟢

• Contextual name: 🛡️ Elastic Pool is underutilized🟢
• ID: /ce/ca/azure/sql-database/elastic-pool-underutilized
• Tags:
  • 🟢 Policy with categories
  • 🟢 Policy with type
  • 🟢 Production policy
• Policy Type: COMPLIANCE_POLICY
• Policy Categories: COST, PERFORMANCE

Logic

• 🧠 prod.logic.yaml🟢
  • 📗 Azure SQL Elastic Pool
  • 🔌 Azure SQL Elastic Pool - object.extracts.yaml
  • 🧪 test-data.json

Description

Open File

Description

This policy identifies Azure SQL Elastic Pools that are underutilized based on their performance metrics over the past 30 days. An Elastic Pool is flagged as underutilized if it meets the following criteria:

• DTU-based pools: Average DTU consumption is below 20% and average storage utilization is below 10%.
• vCore-based pools: Average CPU utilization is below 20% and average storage utilization is below 10%.

Rationale

Oversized Elastic Pools lead to unnecessary cloud costs. Elastic Pools are intended to efficiently manage multiple databases with variable performance demands. However, consistently underutilized pools result in wasted resources and spending. Identifying and rightsizing these pools allows organizations to optimize costs while maintaining required performance levels for applications.

Impact

Before resizing, it is essential to analyze historical performance data to ensure that the new configuration can handle periodic or seasonal peaks in workload demand. Excessive downsizing could result in performance bottlenecks.

... see more

Remediation

Open File

Remediation

Before performing any changes, review historical performance metrics to ensure the new configuration can accommodate periodic or seasonal peaks.

Resize the Elastic Pool

From Azure CLI

az sql elastic-pool update \
    --resource-group {{resource-group}} \
    --server {{server-name}} \
    --name {{pool-name}} \
    --edition {{Standard | GeneralPurpose}} \
    --capacity {{DTU or vCore count}} \
    --db-min-capacity {{min-capacity}} \
    --db-max-capacity {{max-capacity}} \
    --storage {{max-size}} \
    [--family {{Gen5}}]

• DTU-based pools:

  • --edition Standard (or Basic/Premium).
  • --capacity = total DTUs for the pool.
  • --db-min-capacity / --db-max-capacity = min/max DTU per database.
  • Omit --family.

• vCore-based pools:

  • --edition GeneralPurpose (or BusinessCritical).
  • --capacity = total vCores for the pool.
  • --db-min-capacity / --db-max-capacity interpreted as min/max vCores per database.
  • Add --family Gen5.

---

From PowerShell

Set-AzSqlElasticPool `

... [see more](remediation.md)

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