Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jayam.cnu
Starting Member
45 Posts |
 Posted - 2012-04-23 : 08:48:11
|
| 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....Sreenivasulu.p,Mail ID: sreenivas.puliverthi@gmail.com |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-23 : 12:05:43
|
| Analyse the query behind for population datasets. Are you using dimension tables as source? are you using single procedure or seperate procedure for each? DO dimension tables have proper indexes in case size is large?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Reportin Srvices Performanc in SQL Srver 2008 R2