How can we improve Microsoft Azure SQL Data Warehouse ?

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.

10 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Rajeev shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
under review  ·  AdminSQL DW Team (Feedback, Microsoft Azure) responded  · 

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.

1 comment

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • Neil Palmer commented  ·   ·  Flag as inappropriate

    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).

Feedback and Knowledge Base