Forum Discussion

Nimraz007's avatar
Nimraz007
New Member
2 years ago

sql endpoint take long time to run query

My SQL endpoint has been experiencing issues since yesterday. Queries that used to take 10 to 15 seconds are now taking 5 to 6 hours to run, which is also causing the Power BI service refresh to fail

Need Help

2 Replies

  • Nimraz007's avatar
    Nimraz007
    New Member
    2 years ago

    It's showing that the program name 'DMS' is blocking some session IDs. Could this be the cause? Could you please explain this?

    • ahadkarimi's avatar
      ahadkarimi
      Icon for Solution Specialist rankSolution Specialist
      2 years ago

      Hey Nimraz007,
      Absolutely! The 'DMS' program blocking those sessions could be what's causing your SQL queries to drag on. When a session is blocked, it holds onto a resource that other sessions need, which causes everything to slow down. This is likely why your Power BI refreshes are failing too. You'll want to identify and sort out that blocking session to get things back on track.

      Did I answer your question? If so, please mark my post as the solution! ✔️
      Your Kudos are much appreciated! Proud to be a Solution Supplier!