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)
Visszajelzés
https://aka.ms/ContentUserFeedback.
Hamarosan elérhető: 2024-ben fokozatosan kivezetjük a GitHub-problémákat a tartalom visszajelzési mechanizmusaként, és lecseréljük egy új visszajelzési rendszerre. További információ:Visszajelzés küldése és megtekintése a következőhöz: