dbo.slo_assignment_history (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.

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.

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.

Permissions

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

Examples

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;  

See Also

Managing Premium Databases