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
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για