GA Azure SQL Database elastic pools
Microsoft announced (General Availability) GA Azure SQL Database elastic pools on 12th May 2016. Azure SQL Database elastic pools are ideally suited for SaaS and line-of-business applications that need the performance, availability, and security isolation benefits of provisioning one database for each tenant or application. Each elastic database in the pool gets the resources it needs when it needs them, which eliminates the complexity of managing individual database performance. Elastic pools provide the best price performance for a group of databases while delivering performance elasticity for each database. Elastic pool features include:
Auto scaling you control: Pools automatically scale performance and storage capacity for elastic databases on the fly. You can control the performance assigned to a pool, add or remove elastic databases on demand, and define performance of elastic databases without affecting the overall cost of the pool.
Intelligent management of your environment: Built-in sizing recommendations proactively identify databases that would benefit from pools and allow “what-if” analysis for quick optimization to meet your performance goals. Rich performance monitoring and troubleshooting dashboards help you visualize historical pool utilization.
Performance and price that meet your needs: Basic, Standard, and Premium pools offer a broad spectrum of performance, storage, and pricing options. Pools can contain up to 400 elastic databases. Elastic databases can auto scale up to 1,000 elastic database transaction units (eDTUs).
Please note that in a few regions, elastic pools will remain in public preview for a limited time. For a list of these regions, please visit the SQL Database pricing page. For more information on elastic pools, please visit: What is an Azure elastic database pool? documentation page, the Azure blog, and the Elastic databases helps SaaS developers tame explosive growth video.
Thanks,
Sarabpreet Singh Anand
Subscribe now to get latest Tips\blog posts in your Inbox
Follow @SQLChamp
Follow @Sarab_SQLGeek