sys.dm_pdw_nodes (Transact-SQL)
Applies to:
Azure Synapse Analytics
Analytics Platform System (PDW)
Holds information about all of the nodes in Analytics Platform System. It lists one row per node in the appliance.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
Column Name | Data Type | Description | Range |
---|---|---|---|
pdw_node_id | int | Unique numeric id associated with the node. Key for this view. |
Unique across the appliance, regardless of type. |
type | nvarchar(32) | Type of the node. | 'COMPUTE', 'CONTROL', 'MANAGEMENT' |
name | nvarchar(32) | Logical name of the node. | Any string of appropriate length. |
address | nvarchar(32) | IP address of this node. | In the format of [0-255].[0-255].[0-255].[0-255]. |
is_passive | int | Indicates whether the virtual machine running the node is running on the assigned server or has failed over to the spare server. | 0 - node VM is running on the original server. 1 - node VM is running on the spare server. |
region | nvarchar(32) | The region where the node is running. | 'PDW', 'HDINSIGHT' |
See Also
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za