# Idle Azure SQL Elastic Pool Without Databases

Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/idle-azure-sql-elastic-pool-without-databases

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

# Idle Azure SQL Elastic Pool Without Databases

## Explanation

An Azure SQL Elastic Pool continues to incur costs even if it contains no databases. This can occur when databases are deleted, migrated to single-instance configurations, or consolidated elsewhere - but the pool itself remains provisioned. In such cases, the pool becomes an idle resource consuming budget without delivering value.

This inefficiency often goes undetected in large or decentralized environments where cleanup workflows are manual or inconsistent. Since the pool reserves compute and storage regardless of usage, it silently contributes to unnecessary spend over time.

## Relevant Billing Model

- Azure SQL Elastic Pools are billed based on:

- Provisioned compute (eDTUs or vCores)

- Allocated storage

- Charges continue even when no databases are attached to the pool

## Detection

- Identify SQL Elastic Pools with zero active databases

- Review recent database migration or deletion activity to determine whether the pool was previously used

- Evaluate whether the pool is intentionally retained for future deployment or placeholder provisioning

- Confirm that no scheduled reallocation or redeployment is planned

## Remediation

- Decommission any Elastic Pool with no active databases unless a valid business case exists for retaining it

- Review infrastructure-as-code templates and automation pipelines to ensure pool cleanup is included in deprovisioning workflows

- Establish periodic audits to catch and remove idle pools across subscriptions and teams

## Relevant Documentation

- [What are Azure SQL Elastic Pools?](https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview)

- [Azure SQL Database Pricing](https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/elastic/)

[Submit Feedback](https://hub.pointfive.co/inefficiencies/idle-azure-sql-elastic-pool-without-databases)

## At a glance

Reference

CER-0138

Cloud provider

Azure

Service

Azure SQL

Category

[Databases](https://www.pointfive.co/efficiency-hub/service-category/databases)

Inefficiency type

Unused Resource

## Contributed by

- Prasanna Ravichandran 

### Prasanna Ravichandran

Member @ IAPP

[LinkedIn](https://www.linkedin.com/in/prasanravic-cloud-finops-arch/)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.