Export (0) Print
Expand All

dbo.slo_database_objectives

SQL Server 2014
Important note Important

This feature is in a preview state. 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 the assignment status of a Service Level Objective (SLO) in a SQL Database.

Applies to: Azure 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.

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

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;

Community Additions

ADD
Show:
© 2014 Microsoft