Export (0) Print
Expand All

sys.dm_operation_status (Windows Azure SQL Database)

SQL Server 2014

Returns information about operations performed on databases in a Azure SQL Database server.

Applies to: Azure SQL Database.

Column Name

Data Type

Description

session_activity_id

uniqueidentifier

ID of the operation. Not null.

res_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. For example, CREATE, ALTER, and so on.

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 range from 0 to 100. Not null.

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:

  • Create database

  • Copy database

  • Alter database

  • Change the performance level of a service tier

  • Change the service tier of a database. For example from Basic to Standard.

  • Setting up a Active Geo-Replication relationship

  • Terminating a Active Geo-Replication relationship

  • Restore database

  • Delete database

Community Additions

ADD
Show:
© 2014 Microsoft