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

SQL and Parallel Data Warehouse Dynamic Management Views

Cập nhật lần cuối vào 2017-03-07