sys.dm_pdw_component_health_active_alerts (Transact-SQL)

Applies to: Analytics Platform System (PDW)

Stores active alerts on Analytics Platform System (PDW) 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
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
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
create_time	datetime	Time and date when the alert was generated.	NOT NULL

For information about the maximum rows retained by this view, see "Minimum and Maximum Values" in the Analytics Platform System (PDW) product documentation.

See Also

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