Last post Feb 29, 2012 03:44 AM by daisydain
Feb 28, 2012 11:23 AM|sdnd2000|LINK
Hi, I got quite slow performance of reporting service. It takes 2 mins to load up. What are the usual ways to improve the performance. Thanks
Feb 28, 2012 11:34 AM|Srikanth Kasturi|LINK
Can you be little specific of which is slower ? Retrieval of reports from the reporting manager ? or Are you using .Net to pull up these reports from report server.
Feb 28, 2012 01:59 PM|sdnd2000|LINK
I think it is the retrieval from the reporting manager.Basically, I have some filters, and most of the queries are store procedures and it takes time. not sure why.
Feb 29, 2012 03:42 AM|Nishantg|LINK
Most of the time its query which cause the performance issue, and as in your case also I think its your query is the reason because you said your parameters are taking time to fill. Please try to work on your query to get the result faster. If this not help
then please describe in full detail that what's the reason for slow process.
Feb 29, 2012 03:44 AM|daisydain|LINK
If you can post the query or Sp by which you are retrieving the data then we might help you better.