Skip to content

sys-database-service-objectives-azure-sql-database.md

Latest commit

 

History

History
77 lines (59 loc) · 4.79 KB

sys-database-service-objectives-azure-sql-database.md

File metadata and controls

77 lines (59 loc) · 4.79 KB
title sys.database_service_objectives
titleSuffix Azure SQL Database & Azure Synapse Analytics & SQL database in Fabric
description sys.database_service_objectives returns the edition (service tier), service objective (pricing tier), and elastic pool name, if any, for an Azure SQL database or a dedicated SQL pool in Azure Synapse Analytics.
author rwestMSFT
ms.author randolphwest
ms.reviewer wiassaf
ms.date 11/18/2025
ms.service azure-sql-database
ms.topic reference
ms.custom
ignite-2025
f1_keywords
DATABASE_SERVICE_OBJECTIVES_TSQL
dev_langs
TSQL
keywords
elastic pool
elastic pool, management
monikerRange =azuresqldb-current || =azure-sqldw-latest || =fabric-sqldb

sys.database_service_objectives

[!INCLUDE asdb-asa]

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 the current database context is the master database in an Azure SQL Database logical server, returns information on all databases.

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.

To change the service settings, see ALTER DATABASE (Azure SQL Database) and ALTER DATABASE (Azure Synapse Analytics).

For dedicated SQL pools in Azure Synapse Analytics, you must be connected to the master database. This applies to both dedicated SQL pools in Azure Synapse workspaces and dedicated SQL pools (formerly SQL DW). This catalog view is not supported in serverless SQL pools in Azure Synapse Analytics.

Examples

This query returns the name, service, service objective, and elastic pool name (if present) of the current database context.

SELECT  d.name, slo.edition, slo.service_objective, slo.elastic_pool_name
FROM sys.database_service_objectives AS slo
JOIN sys.databases d ON slo.database_id = d.database_id
WHERE d.name = DB_NAME();

Next step

[!div class="nextstepaction"] Monitor Azure SQL Database with Azure Monitor

Related content