SOLVED: Get the Service Tier for an Azure SQL Managed Instance using T-SQL query
The Service Tier is displayed on the General tab of the Server Properties of an Azure SQL Managed Instance. This property doesn't seem to be exposed by SMO however the SQL Server Management Studio SSMS is actually running the following: https://learn.microsoft.com/sql/relational-databases/system-catalog-views/sys-server-resource-stats-azure-sql-database SELECT TOP 1 [sku] AS [Service Tier] FROM master.sys.server_resource_stats ORDER BY [start_time] DESC