Skip to main content

Posts

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: 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