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  ,
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 ,

    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.