Synapse dedicated SQL pool - 100% Cost in estimated plan for "Compute to Control Node"

Paul Hernandez 631 Reputation points Microsoft Employee
2021-10-29T08:54:32.83+00:00

Hi everyone,

I am trying to understand an estimated execution plan for a query running on an sql dedicated pool.

The cost is 100% allocated to the operation "Compute to Control Node".

What does it mean?

We are trying to determine if it worths to create a partition in a small table (only 200K rows) or not. I think compare the two plans could be an option but I cannot understand them and cannot find online documentation.

Could someone please provide some documentation links regarding execution plans on dedicated pools, or is this info currently not available?

BR.
Paul

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,365 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-10-29T13:45:58.68+00:00

    Can you post the XML query plan here https://www.brentozar.com/pastetheplan/.

    In answer to your question, partitioning is generally not a query performance enhancement tool. With proper indexing, partitioning will not help query performance.

    Partitioning a table that small, will not have any performance impact. Partitioning is really only useful for loading/unloading large amounts of data. For example, billions of rows per month, and you only want to keep a rolling 12 months of data in the table.