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.
This video will
- Show you how to create a SQL elastic pool
- Assign databases to a SQL elastic Pool
- Discuss some of the advantages and disadvantages