How to identify your Azure SQL Database’s Tier and Performance Level

If you are looking to quickly check your Azure SQL Database’s Tier and Performance Level, the following may assist you:
 
First connect to the database and then run the following code:
 

SELECT
 PARSENAME(CAST(SERVERPROPERTY('ProductVersion') AS nvarchar(20)),4) AS Product_Version
,COALESCE(DATABASEPROPERTYEX(DB_NAME(),'Edition'),'NA') AS Tier
,COALESCE(DATABASEPROPERTYEX(DB_NAME(),'ServiceObjective'),'NA') AS Performance_Level

 
image01
If the Performance Level doesn’t show, you are likely on an older SQL Server 2012 database (Product_Version 11) as these databases do not currently appear to report the value correctly.
 
image02

Leave a Reply