Form the first glance it may seem to be complicated to calculate price of hosting your database on Azure SQL. We`re simplifying this in below article.
Basic tier
Is a Best fit for a database of small size. It could be a database used for development or testing purposes, or some small application which doesn`t produce too many database operations.
| DATABASE THROUGHPUT UNITS | DATABASE SIZE | POINT IN TIME RESTORE | PRICE | |
| B | 5 | 2 GB | 7 Days | $0.0067/hr (~$5/mo) |
Standard tier
Will be a good fit for an application with about 10-20 concurrent users or even more if they do not produce much database operations.
| DATABASE THROUGHPUT UNITS | DATABASE SIZE | POINT IN TIME RESTORE | PRICE | |
| S0 | 10 | 250 GB | 14 Days | $0.0202/hr (~$15/mo) |
| S1 | 20 | 250 GB | 14 Days | $0.0403/hr (~$30/mo) |
| S2 | 50 | 250 GB | 14 Days | $0.1008/hr (~$75/mo) |
| S3 | 100 | 250 GB | 14 Days | $0.2016/hr (~$150/mo) |
Premium tier
Database on a premium tier will support rather high volume of transactions and concurrent users. Database for some mission critical application could be a good example.
| DATABASE THROUGHPUT UNITS | DATABASE SIZE | POINT IN TIME RESTORE | PRICE | |
| P1 | 125 | 500 GB | 35 Days | $0.625/hr (~$465/mo) |
| P2 | 250 | 500 GB | 35 Days | $1.25/hr (~$930/mo) |
| P3 | 1000 | 500 GB | 35 Days | $5/hr (~$3,720/mo) |
What is point in time restore?
Ability to restore your database to the state in the past.
What is database throughput units or DTU
DTU is a blended metric which describes database performance. It incorporates CPU, Memory and IO.
