Hi All
Since we got change in Azure SQL DB tiers last week - and have now P15 tier, I have collected some data about the tiers and put it all in 1 table.
I collected data from 3 sources:
- Prices from MSFT link: https://azure.microsoft.com/en-us/pricing/details/sql-database/
- All other details documented by MSFT : https://azure.microsoft.com/en-us/documentation/articles/sql-database-service-tiers/?rnd=1
- RAM and CPU by query some DMV's, I took the idea from Tomas Zuber: http://www.tomaszuber.com/2015/09/02/azure-sql-database-p11-and-p4-utilization/ and from Dimitri Furman : https://blogs.msdn.microsoft.com/dfurman/2015/04/02/collecting-performance-counter-values-from-a-sql-azure-database/
Please note - all the DATA is not relevant to:
- Elastic DB pools - collections few Azure SQL DB to a one pool.
- Stretch DB - Migrated Tables from SQL Serve 2016 to Azure SQL DB.
- SQL DWH - DB for DWH in Azure that can be stopped.
Changes can happened during time, the table is Updated for today (2015-08-11)
If you want it in you mail box let me know.
Pini
