sys.dm_pdw_diag_processing_stats (Transact-SQL)
Applies to: Analytics Platform System (PDW)
Displays information related to all internal diagnostic events that could be incorporated into diagnostic sessions defined by the administrator. Query this view to understand the statistics behind the diagnostics and eventing subsystems that drive the population of all the other DMVs. There are a group of queues for each process on each node.
Column Name | Data Type | Description |
---|---|---|
pdw_node_id | int | Appliance node this log is from. |
process_id | int | Identifier of the process running submitting this statistic. |
target_name | nvarchar(255) | The name of the queue. |
queue_size | int | The number of items in the process queue. The queue size is usually 0. A positive number indicates that the system is under stress and is building backlog of events. A positive count in the other columns means system has become corrupted for that particular queue and any related DMVs. |
lost_events_count | bigint | The number of events lost. |
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)