Notifications
Announcements
No record found.
We're currently running Microsoft Dynamics SL. After going through weeks of very sluggish (to the point of crashing) performance it was determined that some SQL query is taking up to 17 seconds and when called is called thousands of times in a row. I'm told that there is no way to determine what module is calling that code. Is that true? Anything I can look at? Thanks.
The bread and butter for any SQL guru is the SQL Server Profiler. Since you already know about the offending query, it's likely you already have some output of the SQL Profiler. If the offending query is from the SL application, the same Profiler provides information about the user involved, the SQL query itself, and the connection information (workstation, network addressing, etc).
The bad scenario might happen if the offending SQL is somehow triggered by the SQL database itself. In that case, the link to the user-module-workstation is blurred. This can happen if there is some add-on in the SQL server itself, as in a replication engine, an auditing tool, a migration engine, a data synchronization engine. You might try to find out additional info on the Profiler results.
Hello,
Sql server profiler found under SSMS tools menu will help you identify long running queries and errors, Support has several templates you can use and we frequently send them to partners for support cases of this nature. Unfortunately there is not a way to attach our profiler templates to the forums. You would need to create a support case to get the templates directly from support.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 663 Most Valuable Professional
André Arnaud de Cal... 540 Super User 2025 Season 2
Sohaib Cheema 348 User Group Leader
