April 23, 2012 at 6:40 am
Hi,
We are using SQL Server 2008 R2 Reporting Services. But we found the performance of Reporting Services is very low, because of much time taking for the selection of rows or values from the drop down of a parameter and the Report generation also taking long time for completion. Nothing but "the performance of drop downs in the reports when there are huge rows to be loaded and having multi select".
So please assist me in this regard, as the users getting effected with this low performance. It is very critical....
April 23, 2012 at 7:29 am
That sounds like a problem with untuned queries, more than a problem with Reporting Services itself.
Have you looked into what the drop-downs are getting their data from? Is it a pre-defined list, or a query? If it's a query, have you gone through the standard steps for optimizing it? Like execution plans, index use, pre-caching, and so on?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply