sys.pdw_health_components (Transact-SQL)

Applies to: Analytics Platform System (PDW)

This view stores information about all components and devices that exist in the system. These components and devices include hardware, storage devices, and network devices.

Column Name Data Type Description Range
component_id int Unique identifier of a component or device.

Key for this view.
NOT NULL
group_id int The logical component group to which this component belongs. See sys.pdw_health_component_groups (Parallel Data Warehouse). NOT NULL
component_name nvarchar(255) Name of the component. NOT NULL

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views