Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
marcoG
Resolver I
Resolver I

How do I view the execution plan for a query?

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

Anonymous
Not applicable

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!