Applies to: Azure SQL Database Azure SQL Managed Instance
Returns information about operations performed on databases in a Azure SQL Database server.
|Column Name||Data Type||Description|
|session_activity_id||uniqueidentifier||ID of the operation. Not null.|
|resource_type||int||Denotes the type of resource on which the operation is performed. Not null. In the current release, this view tracks operations performed on SQL Database only, and the corresponding integer value is 0.|
|resource_type_desc||nvarchar(2048)||Description of the resource type on which the operation is performed. In the current release, this view tracks operations performed on SQL Database only.|
|major_resource_id||sql_variant||Name of the SQL Database on which the operation is performed. Not Null.|
|minor_resource_id||sql_variant||For internal use only. Not null.|
|operation||nvarchar(60)||Operation performed on a SQL Database, such as CREATE or ALTER.|
|state||tinyint||The state of the operation.
0 = Pending
1 = In progress
2 = Completed
3 = Failed
4 = Cancelled
|state_desc||nvarchar(120)||PENDING = operation is waiting for resource or quota availability.
IN_PROGRESS = operation has started and is in progress.
COMPLETED = operation completed successfully.
FAILED = operation failed. See the error_desc column for details.
CANCELLED = operation stopped at the request of the user.
|percent_complete||int||Percentage of operation that has completed. Valid values are listed below. Not NULL.
0 = Operation not started
50 = Operation in progress
For Restore operation 1 to 99 = Operation in progress and indicates how far along the operation is, in percent.
100 = Operation complete
|error_code||int||Code indicating the error that occurred during a failed operation. If the value is 0, it indicates that the operation completed successfully.|
|error_desc||nvarchar(2048)||Description of the error that occurred during a failed operation.|
|error_severity||int||Severity level of the error that occurred during a failed operation. For more information about error severities, see Database Engine Error Severities.|
|error_state||int||Reserved for future use. Future compatibility is not guaranteed.|
|start_time||datetime||Timestamp when the operation started.|
|last_modify_time||datetime||Timestamp when the record was last modified for a long running operation. In case of successfully completed operations, this field displays the timestamp when the operation completed.|
This view is only available in the
master database to the server-level principal login.
To use this view, you must be connected to the
master database. Use the
sys.dm_operation_status view in the
master database of the SQL Database server to track the status of the following operations performed on a SQL Database:
Copy database. Database Copy creates a record in this view on both the source and target servers.
Change the performance level of a service tier
Change the service tier of a database, such as changing from Basic to Standard.
Setting up a Geo-Replication relationship
Terminating a Geo-Replication relationship
The information in this view is retained for approximately 1 hour. Please use the Azure Activity Log to view details of operations in the last 90 days. For retention more than 90 days, consider sending Activity Log entries to a Log Analytics workspace.
Show most recent geo-replication operations associated with database
SELECT * FROM sys.dm_operation_status WHERE major_resource_id = 'myddb' ORDER BY start_time DESC;