dbo.slo_service_objectives (Azure SQL Database)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse
Important

This feature is in a preview state, and has been deprecated in Azure SQL Database V12. Do not take a dependency on the specific implementation of this feature because the feature might be changed or removed in a future release.

Returns Service Level Objective (SLO) information on the current server.

||
|-|
|Applies to: Azure SQL Database V11.|

Column name Data type Description
objective_id uniqueidentifier ID of the service level objective.
name sysname Name of the service level objective.
description nvarchar Description of the service level objective.
create_date datetimeoffset(7) creation date of the service level object on the server.
is_system bit 1 = system service level objective
is_default bit 1 = service level objective is the default SLO.
state tinyint 1 = service level objective is enable.

2 = service level objective is disabled.
state_desc nvarchar Description of the service level objective.
metadata_version decimal Version of the service level objective.

Permissions

This view is available to all user roles with permissions to connect to the virtual master database.

See Also

Managing Premium Databases