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	Range
pdw_node_id	int	Unique identifier of a Analytics Platform System (PDW) node. pdw_node_id, component_id, component_instance_id, alert_id, and alert_instance_id form the key for this view.	NOT NULL
component_id	int	The ID of the component. See sys.pdw_health_components (Transact-SQL). pdw_node_id, component_id, component_instance_id, alert_id, and alert_instance_id form the key for this view.	NOT NULL
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 NULL
alert_id	int	The ID for the alert type. See sys.pdw_health_alerts (Transact-SQL). pdw_node_id, component_id, component_instance_id, alert_id, and alert_instance_id form the key for this view.	NOT NULL
alert_instance_id	nvarchar(36)	Identifies an instance of a given alert. pdw_node_id, component_id, component_instance_id, alert_id, and alert_instance_id form the key for this view.	NOT NULL
previous_value	nvarchar(255)	Used when the alert is of type StatusChange. This is the previous component status. Value is NULL for alerts of type Threshold. See sys.pdw_health_alerts (Transact-SQL) for a list of alert types.	NULL
current_value	nvarchar(255)	Used when the alert is of type StatusChange. This is the current component status. Value is NULL for alerts of type Threshold. See sys.pdw_health_alerts (Transact-SQL) for a list of alert types.	NULL
create_time	datetime	Time and date when the alert was generated.	NOT NULL

See Also

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