Skip to content

Latest commit

 

History

History
31 lines (26 loc) · 1.81 KB

sys-dm-pdw-component-health-status-transact-sql.md

File metadata and controls

31 lines (26 loc) · 1.81 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic dev_langs monikerRange
sys.dm_pdw_component_health_status (Transact-SQL)
sys.dm_pdw_component_health_status (Transact-SQL)
rwestMSFT
randolphwest
03/07/2017
sql
data-warehouse
conceptual
TSQL
>=aps-pdw-2016

sys.dm_pdw_component_health_status (Transact-SQL)

[!INCLUDE pdw]

Holds information about the current health of appliance components.

Column Name Data Type Description Range
pdw_node_id int Not NULL
component_id int The ID of the component. See sys.pdw_health_components (Transact-SQL).

pdw_node_id, component_id, property_id, and component_instance_id form the key for this view.
Not NULL
property_id int The ID of the property. See sys.pdw_health_component_properties (Transact-SQL). NOT NULL
component_instance_id nvarchar(255) Identifies an instance of a component. For example, an instance of a CPU might be identified by component_instance_id='CPU1'.

pdw_node_id, component_id, property_id, and component_instance_id form the key for this view.
NOT NULL
property_value nvarchar(255) The current property value. NULL
update_time datetime The last time the metric was updated. NOT NULL

See Also

Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)