| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|---|
sys.pdw_health_components (Transact-SQL) |
See a reference for the system catalog view sys.pdw_health_components (Transact-SQL) for Analytics Platform System. |
WilliamDAssafMSFT |
wiassaf |
05/12/2022 |
sql |
system-objects |
reference |
kr2b-contr-experiment |
|
>=aps-pdw-2016 |
[!INCLUDE 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 |
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views