Rediger

Del via


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)