FÖRSÄLJNING: 1-800-867-1389
Expand Minimize
EN
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,

sys.dm_operation_status (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see sys.dm_operation_status.

Returns information about operations performed on databases in a Microsoft Azure SQL Database server. The sys.dm_operation_status view is specific to Microsoft Azure SQL Database and is not supported in on-premise SQL Server.

The sys.dm_operation_status view contains the following fields:

 

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 Azure 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 Azure SQL Database only.

major_resource_id

sql_variant

Name of the Azure 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 Azure SQL Database. For example, CREATE, ALTER, and so on.

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 Azure SQL Database server to track the status of the following operations performed on a Azure SQL Database:

  • Create database

  • Copy database

  • Alter database

Var detta till hjälp?
(1500 tecken kvar)
Tack för dina kommentarer

Gruppinnehåll

Lägg till
Visa:
© 2014 Microsoft