sys.dm_pdw_component_health_active_alerts (Transact-SQL)

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

Stores active alerts on Parallel Data Warehouse 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
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 Parallel Data Warehouse product documentation.

See Also

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