MS Azure : SQL Database Service Pricing Tier Part - 1

SQL Database Service Pricing Tier

On the top layer Database pricing is classified in two models:

A. Single Database

Single databases are fully isolated databases optimized for workloads when performance demands are somewhat predictable. You can scale a single database up or down through the Basic, Standard and Premium service tiers to get the performance and features your app needs, precisely when it needs them. Each tier is distinguished primarily by performance, which is measured in Database Transaction Units (DTUs).

B. Elastic Pool

Elastic pools let you manage the collective performance of a pool of databases rather than single databases. The databases in the pool automatically scale up and down to meet demand. You can easily add and remove databases from the pool, scaling your app from a handful of databases to thousands, all within a budget you control.

In the first release of the SQL Database service pricing tier, there were two type of configuration:
1. Web DB - Web Database is basically for web sites and web apps, its limited up to 5GB.
2. Business DB - Business database is basically for data-warehouse and for big project, its limited up to 150 GB.

In the current configuration of the SQL Database Service pricing tier are distinguished in three categories:
1. Basic
2. Standard
3. Premium

These tiers distinguished based on following characteristics:
1. Size : Size limit of the database.
2. Performance : Performance of the database which is measured in DTUs ( Database Transaction Units ).
3. Concurrency : Concurrency related to login attemps, sessions and work threads, we will discuss more about this.
4. Recovery : Recovery is directly related to Point in Time Restore, which is different for each category of pricing tier.
5. Features : There are few advance features which are only available in high tiers like In-memory OLTP, Column-store Indexes.

Now Lets discuss the Current Categories of SQL Database Service pricing tier for Single Database model, which is most commonly used in comparison to Elastic Pool Model.

A. Single Database

1. Basic : There is only 1 type, which is known as B.
Size Limit : 2 GB Max storage per DB
Performance : 5 DTUs
Recovery : Point in Time Restore 7 Days.
Features : Doesn't Supports In-memory OLTP and Column-store Indexes

2. Standard : Standard is further distinguished in 4 type as follows:
Size Limit : 250 GB Max storage per DB
Performance : 10-100 DTUs
Recovery : Point in Time Restore 35 Days.
Features : Doesn't Supports In-memory OLTP and Column-store Indexes

3. Premium : Premium is further distinguished in 6 type as follows:
Size Limit : 500-1024 GB Max storage per DB
Performance : 125-4000 DTUs
Recovery : Point in Time Restore 35 Days.
Features : Supports In-memory OLTP and Column-store Indexes

Concurrency : Concurrency is based on Login Attempts, Worker Threads and Sessions per database details are different for each Tier:

Click here for Elastic Pool

Click Here , For more details and exact pricing.