| title | sys.dm_pdw_component_health_alerts (Transact-SQL) | |
|---|---|---|
| description | sys.dm_pdw_component_health_alerts stores previously issued alerts on appliance components. | |
| author | rwestMSFT | |
| ms.author | randolphwest | |
| ms.date | 03/31/2025 | |
| ms.service | sql | |
| ms.subservice | data-warehouse | |
| ms.topic | conceptual | |
| dev_langs |
|
|
| monikerRange | >=aps-pdw-2016 |
[!INCLUDE pdw]
Stores previously issued alerts on appliance components.
| Column Name | Data Type | Description |
|---|---|---|
pdw_node_id |
int | Unique identifier of a [!INCLUDE ssPDW] 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.