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

OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2

Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of  extended support with Microsoft t...