Export (0) Print
Expand All

dbo.slo_service_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 Service Level Objective (SLO) information on the current server.

Applies to: Azure SQL Database.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft