Forum Discussion

joeshmo's avatar
joeshmo
New Member
1 year ago
Solved

Azure Synapse Pool help needed

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 stag...
data engineering
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    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's avatar
v-nmadadi-msft
Community Support
1 year ago

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