Search This Blog

Wednesday, 21 February 2018

Azure SQL Elastic Pools

In this video tutorial David talks you through the benefits of Azure SQL Elastic pools. Elastic pools allow you to share compute power between different Azure databases. This can be particularly useful if you have databases with differing or varying performance requirements.

With Azure SQL Database you can allocate DTUs to a database. DTU stand for Database Transaction Units, which is how azure SQL Database measures compute power. In an elastic pool multiple databases can share DTUs amongst themselves as and when they need them which can results in better performance and cost savings.