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.

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

Any questions please feel free to leave them in the comments

No comments:

Post a Comment

Featured post

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database? If you work in a hybrid environment with some databases stored on your on ...