Skip to content

sys-dm-operation-status-azure-sql-database.md

Latest commit

 

History

History
92 lines (74 loc) · 5.46 KB

sys-dm-operation-status-azure-sql-database.md

File metadata and controls

92 lines (74 loc) · 5.46 KB

title: "sys.dm_operation_status (Azure SQL Database) | Microsoft Docs" ms.custom: "" ms.date: "06/05/2017" ms.prod: "" ms.prod_service: "sql-database, sql-data-warehouse" ms.reviewer: "" ms.service: "sql-database" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:

  • "dm_operation_status_TSQL"
  • "dm_operation_status"
  • "sys.dm_operation_status"
  • "sys.dm_operation_status_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "dm_operation_status dynamic management view"
  • "sys.dm_operation_status dynamic management view" ms.assetid: cc847784-7f61-4c69-8b78-5f971bb24d61 caps.latest.revision: 17 author: stevestein ms.author: sstein manager: craigg monikerRange: "= azuresqldb-current || = azure-sqldw-latest || = sqlallproducts-allversions"

sys.dm_operation_status (Azure SQL Database)

[!INCLUDEtsql-appliesto-xxxxxx-asdb-asdw-xxx-md]

Returns information about operations performed on databases in a [!INCLUDEssSDSfull] 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 [!INCLUDEssSDS] 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 [!INCLUDEssSDS] only.
major_resource_id sql_variant Name of the [!INCLUDEssSDS] 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 [!INCLUDEssSDS], 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. Values are not continuous and the valid values are listed below. Not NULL.

0 = Operation not started
50 = Operation in progress
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.

Permissions

This view is only available in the master database to the server-level principal login.

Remarks

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 [!INCLUDEssSDS] server to track the status of the following operations performed on a [!INCLUDEssSDS]:

  • Create database

  • Copy database. Database Copy creates a record in this view on both the source and target servers.

  • Alter database

  • 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

  • Restore database

  • Delete database

Example

Show most recent geo-replication operations associated with database ‘mydb’.

SELECT * FROM sys.dm_ operation_status   
   WHERE major_resource_id = ‘myddb’   
   ORDER BY start_time DESC;

See Also

Geo-Replication Dynamic Management Views and Functions (Azure SQL Database)
sys.dm_geo_replication_link_status (Azure SQL Database)
sys.geo_replication_links (Azure SQL Database)
ALTER DATABASE (Azure SQL Database)