Azure Elastic Pool and Elastic Job

What is Elastic Pool: As the name suggests it is a pool of SqlAzure Dbs.

  1. Each elastic pool contains sets to SqlAzure dbs.
  2. Elastic pool has shared capacity among SqlAzure dbs.
  3. Elastic pool ensures best use of capacity and resource.
  4. It is very much cost effective also.
  5. Best option for dealing with unexpected db load at same time remaining cost effective.
  6. While creating elastic pool, Azure provides suggestion about which db to include in the pool and about min mac DTU, bases on DTU usages of Dbs.

Example: Let’s assume you have 10 basic SqlAzure dbs, which normally use 5 DTUs. During setup in Azure you assign each Db 10 DTU (considering scaling\peak) i.e total 100 DTU while most often consumption is 50 DTUs on average. So, you are paying for 50 DTU extra i.e double.

By putting then in elastic pool and setting the max DTU at a level (for ex: 60), you can handle unexpected db load and achieve cost effective solution.

P.S: In the above example, there is an assumption that all dbs don’t achieve peak at the same time.
Continue reading “Azure Elastic Pool and Elastic Job”