sys.dm_pdw_component_health_status (Transact-SQL)

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

Holds information about the current health of appliance components.

Column Name Data Type Description Range
pdw_node_id int Not NULL
component_id int The ID of the component. See sys.pdw_health_components (Transact-SQL).

pdw_node_id, component_id, property_id, and component_instance_id form the key for this view.
Not NULL
property_id int The ID of the property. See sys.pdw_health_component_properties (Transact-SQL). NOT NULL
component_instance_id nvarchar(255) Identifies an instance of a component. For example, an instance of a CPU might be identified by component_instance_id='CPU1'.

pdw_node_id, component_id, property_id, and component_instance_id form the key for this view.
NOT NULL
property_value nvarchar(255) The current property value. NULL
update_time datetime The last time the metric was updated. NOT NULL

See Also

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