Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Azure SQL Database
Azure Synapse Analytics
SQL database in Microsoft Fabric Preview
Returns the edition (service tier), service objective (pricing tier), and elastic pool name, if any.
Returns data only in Azure SQL database, SQL database in Fabric, or dedicated SQL pool in Azure Synapse Analytics.
- If logged on to the
masterdatabase in an Azure SQL Database logical server, returns information on all databases. - For dedicated SQL pools in Azure Synapse Analytics, you must be connected to the
masterdatabase. This applies to both dedicated SQL pools in Azure Synapse workspaces and dedicated SQL pools (formerly SQL DW).
Result set
| Column Name | Data type | Description |
|---|---|---|
database_id |
int | The ID of the database, unique within the logical server. Joinable with sys.databases on the database_id column, but with not other system views where the database_id column is present. For details, see DB_ID. |
edition |
sysname | The service tier for the database or data warehouse: Basic, Standard, Premium or Data Warehouse. |
service_objective |
sysname | The pricing tier of the database. If the database is in an elastic pool, returns ElasticPool. On the Basic tier, returns Basic. Single database in a standard service tier returns one of the following: S0, S1, S2, S3, S4, S6, S7, S9 or S12. Single database in a premium tier returns of the following: P1, P2, P4, P6, P11 or P15. Azure Synapse Analytics returns DW100 through DW30000c. SQL database in Fabric returns FabricSQLDB always. |
elastic_pool_name |
sysname | The name of the elastic pool that the database belongs to. Returns NULL if the database is a single database or a dedicated SQL pool. |
Permissions
Requires dbManager permission on the master database. At the database level, the user must be the creator or owner.
Remarks
For details on service objectives, see single databases, elastic pools. For Azure Synapse Analytics, see DWUs. For information on pricing, see SQL Database options and performance: SQL Database Pricing and Azure Synapse Analytics Pricing.
To change the service settings, see ALTER DATABASE (Azure SQL Database) and ALTER DATABASE (Azure Synapse Analytics).
This catalog view is not supported in serverless SQL pools in Azure Synapse Analytics.
Examples
This query returns the name, service, and performance tier information of the current database context.
SELECT DB_NAME(), slo.edition, slo.service_objective
FROM sys.database_service_objectives AS slo
WHERE slo.database_id = DB_ID();