| title | sys.dm_pdw_query_stats_xe (Transact-SQL) | |
|---|---|---|
| description | sys.dm_pdw_query_stats_xe (Transact-SQL) | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 03/07/2017 | |
| ms.service | sql | |
| ms.subservice | system-objects | |
| ms.topic | reference | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016 |
[!INCLUDE pdw]
This DMV is deprecated and will be removed in a future release. In this release, it returns 0 rows.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| event | nvarchar(60) | Key for this view. | |
| event_id | nvarchar(36) | ||
| create_time | datetime | ||
| session_id | int | The id for the session. | See session_id in sys.dm_pdw_exec_sessions (Transact-SQL). |
| cpu | int | ||
| reads | int | Number of logical reads since the start of the event. | |
| writes | int | Number of logical writes since the start of the event. | |
| sql_text | nvarchar(4000) | ||
| client_app_name | nvarchar(255) | ||
| tsql_stack | nvarchar(255) | ||
| pdw_node_id | int | Node on which this Xevent instance is running. |
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)