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)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za