sys.dm_pdw_component_health_alerts (Transact-SQL)
Applies to: 
Analytics Platform System (PDW)
Stores previously issued alerts on appliance components.
| Column Name | Data Type | Description |
|---|---|---|
pdw_node_id |
int | Unique identifier of a Analytics Platform System (PDW) node. Not nullable. |
component_id |
int | The ID of the component. For more information, see sys.pdw_health_components. Not nullable. |
component_instance_id |
nvarchar(255) | pdw_node_id, component_id, component_instance_id, alert_id, and alert_instance_id form the key for this view. Not nullable. |
alert_id |
int | The ID for the alert type. For more information, see sys.pdw_health_alerts. Not nullable. |
alert_instance_id |
nvarchar(36) | Identifies an instance of a given alert. Not nullable. |
previous_value 2 |
nvarchar(255) | Used when the alert is of type StatusChange. This is the previous component status. Value is NULL for alerts of type Threshold. Nullable. |
current_value 2 |
nvarchar(255) | Used when the alert is of type StatusChange. This is the current component status. Value is NULL for alerts of type Threshold. Nullable. |
create_time |
datetime | Time and date when the alert was generated. Not nullable. |
1 pdw_node_id, component_id, component_instance_id, alert_id, and alert_instance_id form the key for this view.
2 See sys.pdw_health_alerts for a list of alert types.