sys.pdw_health_alerts (Transact-SQL)
Applies to:
Analytics Platform System (PDW)
This view stores properties for the different alerts that can occur on the system. This table is a catalog table for alerts.
Column Name | Data Type | Description | Range |
---|---|---|---|
alert_id | int | Unique identifier of the alert. Key for this view. |
NOT NULL |
component_id | int | ID of the component this alert applies to. The component is a general component identifier, such as "Power Supply," and is not specific to an installation. See sys.pdw_health_components (Transact-SQL). | NOT NULL |
alert_name | nvarchar(255) | Name of the alert. | NOT NULL |
state | nvarchar(32) | State of the alert. | NOT NULL Possible values: 'Operational' 'NonOperational' 'Degraded' 'Failed' |
severity | nvarchar(32) | Severity of the alert. | NOT NULL Possible values: 'Informational' 'Warning' 'Error' |
type | nvarchar(32) | Type of alert. | NOT NULL Possible values: StatusChange - The device status has changed. Threshold - A value has exceeded the threshold value. |
description | nvarchar(4000) | Description of the alert. | NOT NULL |
condition | nvarchar(255) | Used when type = Threshold. Defines how the alert threshold is calculated. | NULL |
status | nvarchar(32) | Alert status | NULL |
condition_value | bit | Indicates whether the alert is allowed to occur during system operation. | NULL Possible values 0 - Alert is not generated. 1 - Alert is generated. |
See Also
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru