topic How do I view the execution plan for a query? in Data Warehouse

How do I view the execution plan for a query?

marcoG — Tue, 05 Dec 2023 08:42:50 GMT

I have performance problems with queries on Fabric Warehouse and Lakehouse which I don't experience on synapse serveless sql pools.

I would like to analyze query execution plans on sql server management studio I get this error:
Microsoft SqlClient Data Provider Framework: Message 15869, Level 16, State 3, Line 1
SHOWPLAN_XML is not supported for SET.

Do you have any ideas?

Thank you

Re: How do I view the execution plan for a query?

Anonymous — Tue, 05 Dec 2023 11:08:31 GMT

Hi marcoG ,

We are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.

Re: How do I view the execution plan for a query?

Anonymous — Wed, 06 Dec 2023 04:28:54 GMT

Hi marcoG ,

At this time, SHOWPLAN_XML/EXPLAIN statements are not supported by Microsoft Fabric DW.
Currently, there are plans to expose the query plan in query insights view.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Please let me know if you have any further queries.