sys.dm_pdw_os_performance_counters (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database noAzure SQL Data Warehouse yesParallel Data Warehouse

Contains information about Windows performance counters for the nodes in Parallel Data Warehouse.

Column Name Data Type Description Range
pdw_node_id int The ID of the node that contains the counter.

pdw_node_id and counter_name form the key for this view.
See node_id in sys.dm_pdw_nodes (Transact-SQL).
counter_name nvarchar(255) Name of Windows performance counter.
counter_category nvarchar(255) Name of Windows performance counter category.
instance_name nvarchar(255) Name of the specific instance of the counter.
counter_value Decimal(38,10) Current value of the counter.
last_update_time Datetime2(3) Timestamp of last time the value was updated.

See Also

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