Azure Synapse Pool help needed

[joeshmo]

Hello!

Recently my test warehouse has been running VERY slow (2 times slower than usual) in only one query which has alot of joins etc, it's a stored procedure that takes data from silver to staging.

It started happening after a deploy to test and I´ve since then:

1. Reversed to an old patch where it used to work smoothly (still same issue)

2. Changed performance to match PROD (prod works fine), and still same amount of waiting!

3. Same amount of data in prod and test so it´s not the data amount that makes it slow.

Even with changing back to old patch where it used to work and the code changing back, it´s still the same issue. Any suggestions on what I can look at or what I can do is HIGHELY appreciated!!!

It´s taking alot of time on ShuffleMove operation, changing performance did not work though?

using ssms 19 btw

best regards

joe

[v-nmadadi-msft]

Hi @joeshmo ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks ands regards

[v-nmadadi-msft]

Hi @joeshmo,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so other members can easily find it.
Thanks and regards

[v-nmadadi-msft · Accepted solution]

Hi @joeshmo  ,
Thanks for reaching out to the Microsoft fabric community forum.

1) Try reducing query result set size to help you avoid client-side issues caused by large query results. 
2) Consider using query insights to find out top CPU consuming queries by CPU time and maybe you can optimize the query
Query insights - Microsoft Fabric | Microsoft Learn
3) Follow the below document to actually check weather query performance seems to degrade over time
Troubleshoot the Warehouse - Microsoft Fabric | Microsoft Learn

If nothing worked please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious. 

Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to give "Kudos"

Thanks and Regards

[v-nmadadi-msft]

Hi @joeshmo ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.