Finance | Project Operations, Human Resources, ...

Analysis long running SQL queries

(0) Share

Report

Posted on by CU10121822-0

Hi team,

Please let me the best approach to analysis long running SQL queries.

Pls advise the best approach. Thanks

Categories:

Dynamics 365 Finance

All responses (6)

Answers (0)

Sort by

Suggested answer

Subra 2,478 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU10121822-0

You can use the application monitoring and telemetery to identify the long running queries.

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue
Martin Dráb 241,515 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What exactly do you mean by to analyze? Do you want to find longest running queries in a certain period or find out why a particular query is slow? Or something else?

Also, which kind of environment are you talking about? E.g. the production, a test sandbox or UDE.
André Arnaud de Cal... 307,889 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Your question is too broad. Can you please provide more background information? Are you trying to solve a specific performance issue or is your question theoretical? A performance issue can be caused by long running queries, but also by a lot of smaller queries executed in a loop. Anyway, there are way more root causes for performance degradation. Please elaborate.
CU10121822-0 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin and Andrea

My question is theoretical and I would like to know if I faced such this kind of issue then what is the best approach to analysis and resolve it. I may need to work on support project so like to know to answer for my knowledge.

Pls advise thanks
Martin Dráb 241,515 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, saying just “such this kind of issue” doesn't clarify the topic any better. You'll need to specify of what you actually want. If you can't answer questions asked in my first reply, it must mean that you don't know yet what you want to discuss and your next step should be thinking it through.
André Arnaud de Cal... 307,889 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@CU10121822-0,

I suggest asking a more specific question in case you encounter a support case in future where people complain about performance. As there can be many different root causes, what to do depends on what exactly is perceived as slow.