sys.dm_pdw_exec_requests (Transact-SQL)

THIS TOPIC APPLIES TO: noSQL Server noAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Holds information about all requests currently or recently active in SQL Data Warehouse. It lists one row per request/query.

Column Name Data Type Description Range
request_id nvarchar(32) Key for this view. Unique numeric id associated with the request. Unique across all requests in the system.
session_id nvarchar(32) Unique numeric id associated with the session in which this query was run. See sys.dm_pdw_exec_sessions (Transact-SQL).
status nvarchar(32) Current status of the request. 'Running', 'Suspended', 'Completed', 'Cancelled', 'Failed'.
submit_time datetime Time at which the request was submitted for execution. Valid datetime smaller or equal to the current time and start_time.
start_time datetime Time at which the request execution was started. NULL for queued requests; otherwise, valid datetime smaller or equal to current time.
end_compile_time datetime Time at which the engine completed compiling the request. NULL for requests that have not been compiled yet; otherwise a valid datetime less than start_time and less than or equal to the current time.
end_time datetime Time at which the request execution completed, failed, or was cancelled. Null for queued or active requests; otherwise, a valid datetime smaller or equal to current time.
total_elapsed_time int Time elapsed in execution since the request was started, in milliseconds. Between 0 and the difference between start_time and end_time.

If total_elapsed_time exceeds the maximum value for an integer, total_elapsed_time will continue to be the maximum value. This condition will generate the warning “The maximum value has been exceeded.”

The maximum value in milliseconds is equivalent to 24.8 days.
label nvarchar(255) Optional label string associated with some SELECT query statements. Any string containing 'a-z','A-Z','0-9','_'.
error_id nvarchar(36) Unique id of the error associated with the request, if any. See sys.dm_pdw_errors (Transact-SQL); set to NULL if no error occurred.
database_id int Identifier of database used by explicit context (e.g., USE DB_X). See id in sys.databases (Transact-SQL).
command nvarchar(4000) Holds the full text of the request as submitted by the user. Any valid query or request text. Queries that are longer than 4000 bytes are truncated.
resource_class nvarchar(20) The resource class for this request. See related concurrency_slots_used in sys.dm_pdw_resource_waits (Transact-SQL). SmallRC

MediumRC

LargeRC

XLargeRC

For information about the maximum rows retained by this view, see "Minimum and Maximum Values" in the Parallel Data Warehouse product documentation.

Permissions

Requires VIEW SERVER STATE permission.

Security

sys.dm_pdw_exec_requests does not filter query results according to database-specific permissions. Logins with VIEW SERVER STATE permission can obtain results query results for all databases

Warning

An attacker can use sys.dm_pdw_exec_requests to retrieve information about specific database objects by simply having VIEW SERVER STATE permission and by not having a database-specific permission.

See Also

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)