sys.dm_pdw_component_health_alerts (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database noAzure SQL Data Warehouse yesParallel Data Warehouse

Stores previously issued alerts on appliance components.

Column Name Data Type Description Range
pdw_node_id int Unique identifier of a Parallel Data Warehouse 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

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