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.

See Also

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