sys.dm_pdw_component_health_status (Transact-SQL)

Applies to: Analytics Platform System (PDW)

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