September 16, 2010 at 9:55 am
Problem: All new hardware running SQL 2008 MOSS 2010 (integrated with RS) and all reports are slower than old hardware and SQL 2005/MOSS 2007 but EXTREMELY slower in any version of IE (6,7,8) than in Firefox or Chrome.
Partial Cause: We identified the major performance issue was when reports had dropdowns with large sets of options. Although the initial report parameter screen runs just fine, when the user populates the parameters and runs the report it takes sometimes up to minutes before the "loading" image appears when running in IE. If we take out the dropdown and just have the user key in a value the report performance (although still slower) performance much better and the loading screen appears within seconds.
Has anyone seen this? It shouldn't matter whether I key in a value or select it from a list when it comes to report execution, right? There has to be some logicial explanation for the delay. Any help would be appreciated!
September 16, 2010 at 11:03 am
I don't know if this will help in your situation, but I have heard of situations where a stored procedure was used as the dataset and when the report was run something called Parameter Sniffing was occurring that slowed things down dramatically. I believe the solution is to add another layer of abstraction between your report parameters and your query parameters. I may have seen the reference to Parameter Sniffing here on SSC or elsewhere, but in the specific cases it made a big improvement.
September 16, 2010 at 11:41 am
We did find this KB which seemed to match the issue but after applying the fix there was no performance increase.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply