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)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om