*This post is locked for comments
Hi,
I would recommend using this KB article to run a SQL trace of the slow report running:
967955
How to use SQL Profiler in SQL Server 2008 and SQL Server 2008 R2 to trace database events in Microsoft Dynamics SL
mbs.microsoft.com/.../KBDisplay.aspx
Open the trace and take a look. Look at the process that is actually running (2nd column over) but pay close attention to the Reads, Writes, and Duration columns. These are in milliseconds so 1000 = 1 second. Look for any process taking 10,000ms (10 seconds) or greater.
If you can find a specific process taking quite some time, post back here.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156