MS Azure : Create Elastic Pool

Steps to Create Elastic Pool

Today we will cover the demo to create Elastic Pool.
As you know Elastic pools are well suited for large no. of databases with pattern of low average utilization with relatively infrequent utilization spikes.
Fixed cost per eDTUs, eDTUs are tied to storage.

Lets understand the benefits of Elastic Pool in terms of Pricing Tier through Example:
- 16 S3 Standard Databases : 16X$150 per month = $2400, each db has static 100 DTU. Maximum 250GBX16 Storage = 4TB Storage Total.
- One Standard Pool : (800 eDTU X$2.23) per month =$1784, each db can go 10-100 DTU. 800 GB Storage.
As per above calculations, you can see it is only beneficial for no. of database which are small in size and low utilization.

Demo to Create Elastic Pool
1. Login to Azure Portal with your credentials.

2. Search your SQL Server and click on New Pool.

3. Once you clicked, it will prompt to provide following details to create Elastic Pool:
a. Name : Provide Elastic Pool name.

b. Pricing Tier : Select pricing tier, here we have selected Standard S.

c. Configure pool : Select the no. of Pool eDTUs and Storage Pool GBs both are directly proportional to each other, here we have selected:

Once you clicked on Configure pool, it will shows the below screen where we have to provide details for Elastic database pool Setting.

Both Pool eDTUs and Pool GBs both are directly proportional to each other, once you increase the value of one parameter, second will get auto increased.

Once provided all the configuration setting for elastic pool, then have to choose the database which will be the part of the elastic pool.

Select the databases, here we have select t1 , t2 database.

Now as you can see in below snapshot, t1 & t2 databases are the part of Elastic Pool (Elastic Pool-1).
Elastic Databases : Max limit 200 dbs, as of now 2 databases out of 200 dbs.
Pool Storage : Max size limit 100 GB, .004GB is in used out of 100 GB.

d. Summary & Cost : Once you provided above information, this label field will auto filled with summary and overall cost for Elastic pool.

That's it!! So conclusion is multiple databases can share resources through elastic database pools. The service also offer other elastic database capabilities.