3
votes

I am using Azure SQL Database for storing of my company record. But they are charging really more and it is very expensive. I am using SQL Database Standard edition, so I thought I can move on to basic edition to minimize the expenses. What is the difference between standard and basic edition. Please suggest any solution.

2
Standard & Basic edition of what service? There are many services in Azure.Gaurav Mantri
@GauravMantri : SQL databaseuser5286952
Please see this link: azure.microsoft.com/en-in/pricing/details/sql-database which compares various editions.Gaurav Mantri
@GauravMantri : thank u very much brouser5286952

2 Answers

9
votes

Have a look at this comparison between tiers:

Source

enter image description here

The main information is the DTU (Database Throughput Unit) that allows you to compare tiers.

As of today (10/2015), prices are:

B: $0.0067/hr (~$5/mo)

S0: $0.0202/hr (~$15/mo)
S1: $0.0403/hr (~$30/mo)
S2: $0.1008/hr (~$75/mo)
S3: $0.2016/hr (~$150/mo)

P1: $0.625/hr (~$465/mo)
P2: $1.25/hr (~$930/mo)
P4: $2.50/hr (~$1,860/mo)
P6: $5/hr (~$3,720/mo)
P11:$9.41/hr (~$7,001/mo)

Source

0
votes

For low and middle performance databases the prices are skyrocketing. Going from web to basic explode costs if you have many small databases as I have

That's inacceptable.

The switch to new pricing tiers is in my opinion is a scam. Time to switch to other providers!

Also look here: https://feedback.azure.com/forums/217321-sql-database/suggestions/6848339-please-reconsider-the-new-db-pricing-tiers