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 |
|---|---|---|
pdw_node_id |
int | Not nullable. |
component_id |
int | The ID of the component. For more information, see sys.pdw_health_components. Not nullable. |
property_id |
int | The ID of the property. For more information, see sys.pdw_health_component_properties. Not nullable. |
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'. Not nullable. |
property_value |
nvarchar(255) | The current property value. Nullable. |
update_time |
datetime | The last time the metric was updated. Not nullable. |
1 pdw_node_id, component_id, property_id, and component_instance_id form the key for this view.