Expose DMVs that display the actual execution plan (sqlplan) of a query on a node after the query executes
Currently, DBCC PWD_SHOWEXECUTIONPLAN only displays the *estimated* query plan of the step being executed on a compute node, *while* the query is running. There is no way to see the actual execution plan of the query step on the node.
This prevents us from seeing the details of the query being executed such as the stats on how many rows were estimated vs actual rows returned, or rowgroups eliminated by the ColumnStore index, or any gross under/over estimates in the row counts owing to missing/bad statistics.
Thank you for voting for this feature! We are aware of this scenario and are looking into ways of supporting this and improving our query troubleshooting experience. In the meantime, stay tuned for an update and please continue voting for this feature.
Neil Palmer commented
It would be great to have this functionality.
Using DW Sentry, I can see some plans, but there are many where the estimated plan isn't even shown.
I'd Also love to be able to see plans for ShuffleMove operations as well as On operations (sometimes they have large sql queries attached too, but a plan is never retrieved).