Export (0) Print
Expand All

dbo.slo_assignment_history (Azure SQL Database)

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 history of database SLO assignments in the server, including the following:

  • The history of database SLO assignments in the server.

  • Start and end time of each database SLO change request.

  • Any SLO assignment errors which are recorded in the error_code and error_desc columns.

Applies to: .

Column name

Data type

Description

database_name

sysname

Name of the database.

database_id

int

ID of the database.

create_date

datetimeoffset(7)

Date of database creation.

service_objective_name

sysname

Name of the Service Level Objective (SLO).

service_objective_id

uniqueidentifier

ID of the SLO.

operation_id

uniqueidentifier

ID of the operation.

operation_start_time

datetimeoffset(7)

Start time of the database SLO change request.

operation_end_time

datetimeoffset(7)

End time of the database SLO change request.

error_code

int

Error code of the database SLO change request.

error_desc

nvarchar

Description of the error in the database SLO change request.

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

The following example returns the history of database SLO assignments for a specified database.

SELECT *
FROM dbo.slo_assignment_history 
WHERE database_name = '<DB NAME>’ 
ORDER BY operation_start_time DESC;

Community Additions

ADD
Show:
© 2014 Microsoft