Parallel Data Warehouse RRS feed

All replies

  • Hi Amol,

    Thanks for your feedback. 

    Row Group : It is the group of rows together. 

    Using sys.pdw_nodes_column_store_row_groups command you can get clustered columnstore index information on a per-segment basis to help the administrator make system management decisions in SQL Data Warehouse.

    Nodes : There are three types of Nodes in PDW, Control Node, Compute Node and Management Node.

    Using sys.dm_pdw_nodes command you can get the information about all of the nodes in Analytics Platform System. It lists one row per node in the appliance.

    You can refer this link for more details on Nodes.

    Hope this helps.

    Tuesday, August 20, 2019 5:54 AM
  • Hi Amol,

    I hope the information provided for your concern is helpful. Please "Mark as answer" if it was helpful, so that it can help the other users with same problem.

    If you need more information, please let us know.

    Monday, August 26, 2019 6:20 AM