Josephine Bush shares some tips on using elastic pools in Azure SQL DB:
Main points about elastic pools
- Elastic pools enable you to purchase resources for a pool shared by multiple databases to accommodate unpredictable usage periods by individual databases.
- You can create multiple pools on a server, but you can’t add databases from different servers into the same pool.
- Pools are well-suited for many databases with specific utilization patterns. These patterns are characterized by low average utilization with infrequent utilization spikes for a given database. Conversely, multiple databases with persistent medium-high utilization shouldn’t be placed in the same elastic pool.
All the databases in the elastic pool share the DTU and storage. This is very apparent when multiple persistent medium-high utilization databases are in the same pool, which is why Microsoft advises against it.
Read on to see information about storage, DTUs, noisy neighbors, and more.