Skip to main content


Showing posts from August, 2016

Azure SQL DB - Service Tiers

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: All other details documented by MSFT : RAM and CPU by query some DMV's, I took the idea from Tomas Zuber:  and from Dimitri Furman :   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