The sys.dm_pdw_request_steps DMV is one way to review the metadata regarding the data move operation, if any for the respective query.

SELECT * FROM sys.dm_pdw_request_steps

WHERE request_id = 'QID224136' --Place your request_id here from the prior step.

ORDER BY step_index;

 

Calendar

Description automatically generated with medium confidence

 

Graphical user interface, text, application, table

Description automatically generated

 

SSMS the Display Estimated Execution Plan in the GUI, represents another option to review the estimated distributed query plans data movement required to fulfill the query. When reviewing query joins, it is key to not have any data movements that may be a bottleneck. Consider recreating the distribution of a table if multiple queries are using the same join key. That the table is not distributed under if they are unable to add the current key.

Graphical user interface, diagram, application

Description automatically generated