# Azure SQL Multiple Small DBs Could Use Elastic Pool

> An elastic pool buys one shared allocation for many databases with staggered peaks, instead of provisioning each one for its own peak separately.

Source: https://zop.dev/zopnight/rules/azure-sql-multiple-small-dbs-could-use-elastic-pool

---

_Rightsizing · Medium severity_

## Azure SQL Multiple Small DBs Could Use Elastic Pool

An elastic pool buys one shared allocation for many databases with staggered peaks, instead of provisioning each one for its own peak separately.

- Azure — provider
- Medium — severity
- Savings — where it shows up
- Manual — fix, steps written out

Free to start. No card. The playground just needs your work email.

## Found, explained, handed over.

Findings with a dollar figure attached, idle, oversized, orphaned, unscheduled and undiscounted spend.

- 01. Detect — ZopNight checks this automatically across Azure, with read-only access to the account.
- 02. Explain — Every finding says exactly what to change: Move the SQL database into an elastic pool. Where the saving can be proven it is priced; where it cannot, the finding says so.
- 03. Fix — The finding opens with the fix already written out, step by step, so it is one ticket, not an investigation.

- applies_to_fallback: Any resource in the account
- where_it_appears: The Savings tab of Recommendations, with every affected resource listed.

## Related

- [Azure SQL Database TDE Not Enabled](https://zop.dev/zopnight/rules/azure-sql-database-tde-not-enabled)
- [Azure SQL Database Threat Detection Not Enabled](https://zop.dev/zopnight/rules/azure-sql-database-threat-detection-not-enabled)
- [Azure SQL Right-sizing](https://zop.dev/zopnight/rules/azure-sql-right-sizing)
- [Azure SQL Database Auditing Not Enabled](https://zop.dev/zopnight/rules/azure-sql-database-auditing-not-enabled)
- [Idle Azure SQL Database](https://zop.dev/zopnight/rules/idle-azure-sql-database)
- [Azure SQL Could Use Serverless Tier](https://zop.dev/zopnight/rules/azure-sql-could-use-serverless-tier)

## See the oversized resources in your account.

Connect a read-only role and the first pass runs on your own estate. This check, and the rest of the catalogue, with it.

[object Object]