🛡️ Azure SQL Database serverless auto-pause is disabled🟢

• Contextual name: 🛡️ Database serverless auto-pause is disabled🟢
• ID: /ce/ca/azure/sql-database/serverless-auto-pause-disabled
• Tags:
  • 🟢 Policy with categories
  • 🟢 Policy with type
  • 🟢 Production policy
• Policy Type: BEST_PRACTICE
• Policy Categories: COST

Stats

not available

Logic

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

Description

Open File

Description

Ensure that auto-pause is enabled for eligible Azure SQL Database serverless databases. Auto-pause suspends compute after the configured period of inactivity, which can reduce charges for intermittent workloads.

Rationale

Azure SQL Database serverless automatically scales compute for variable workloads. When auto-pause is enabled, it also pauses inactive databases and resumes them when they receive a new connection. This avoids paying for idle compute while retaining the database and its configuration.

Impact

With auto-pause disabled, an idle serverless database continues to incur compute charges. Enabling it can add resume latency to the first connection after a pause, so it may be unsuitable for workloads that require consistently low connection latency or cannot be paused between scheduled jobs.

Audit

This policy evaluates an Azure SQL Database that uses the General Purpose serverless compute tier.

A Database is marked as INCOMPLIANT when Auto Pause Delay is -1, which means that auto-pause is disabled.

... see more

Remediation

Open File

Remediation

Before you begin

Review connection patterns, scheduled jobs, and the acceptable resume latency. Choose an idle delay that keeps the database active between expected workloads. Confirm that the database is eligible for auto-pause and that pausing is compatible with its replication, backup, and application requirements.

Azure portal

1. Open SQL databases and select the affected database.
2. Select Compute + storage.
3. Select Configure database.
4. Set Auto-pause delay to an appropriate value instead of Disabled.
5. Select Apply.

Azure CLI

az sql db update \
  --resource-group <resource-group-name> \
  --server <server-name> \
  --name <database-name> \
  --auto-pause-delay <idle-delay-in-minutes>

PowerShell

Set-AzSqlDatabase `
  -ResourceGroupName "<resource-group-name>" `
  -ServerName "<server-name>" `
  -DatabaseName "<database-name>" `
  -AutoPauseDelay <idle-delay-in-minutes>

Verify the change

az sql db show \
  --resource-group <resource-group-name> \
  --server <server-name> \

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

policy.yaml

Open File

Linked Framework Sections

Section	Sub Sections	Internal Rules	Policies	Flags	Compliance
💼 Cloudaware Framework → 💼 Resource Optimization			37		no data