dbo.slo_database_objectives (Azure SQL Database)

THIS TOPIC APPLIES TO: noSQL Server yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Important

This applies only to Azure SQL DatabaseV11.

For [!INCLUDEssSDSfull (on master) for the operation ALTER DATABASE.

Returns the assignment status of a Service Level Objective (SLO) in a SQL Database.

Column name Data type Description
database_name sysname Name of the database.
current_slo sysname Current SLO of the database.
target_slo sysname Target SLO of the database as specified in the SLO change request.
state_desc nvarchar Status of SLO change request: completed or pending.

Permissions

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

Examples

SELECT   
database_name=database_name.name   
    , current_slo=current_slo.name   
    , target_slo=target_slo.name   
    , state_desc=database_slo.state_desc   
FROM slo_database_objectives AS database_slo  
INNER JOIN slo_service_objectives AS current_slo ON database_slo.current_objective_id = current_slo.objective_id  
INNER JOIN slo_service_objectives AS target_slo ON database_slo.configured_objective_id = target_slo.objective_id  
INNER JOIN sys.databases AS database_name  ON database_slo.database_id = database_name.database_id;  

See Also

Managing Premium Databases
sys.dm_operation_status (Azure SQL Database)