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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
marcoG
Helper II
Helper II

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

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
v-gchenna-msft
Community Support
Community Support

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.

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.