Tuesday, June 30, 2020

Azure SQL Elastic Pool

Azure SQL Elastic Pools 

Many organizations struggle with unpredictable workloads upon their multiple databases holding various applications. Over-pay to high resources all the time which brought based on peak usage calculations. Compromise on performance by assigning the lower resources and experience ineffective solutions.

Azure Elastic pools allow us to manage multiple databases that have varying performance. In an Elastic pool, multiple databases can share DTUs amongst themselves as and when they need which can result in better performance and cost savings. An Elastic database pool provides elastic database transaction Units (eDTUs) and storage(GBs) that are shared by multiple databases. It also allows us to allocate a shared set of compute resources to a collection of Azure SQL databases, meaning that your databases are running in a shared resource pool on a co-tenanted Azure server over which you have no direct control. The benefit of using an Elastic Pool in Azure SQL Server database is that using it, a single database can be moved in and out of an elastic pool, which gives us flexibility. Elastic pool is a collection of a single database with a shared set of resources, such as CPU or memory. Single databases can be moved into and out of an elastic pool.



from DZone.com Feed https://ift.tt/2Bg72xr

No comments:

Post a Comment