Tuesday, March 20, 2012

Reports Performance Issues

Hi All,

I have some serious performance issues with reporting services, please help me to improve the performance of reporting services,

When I am running SP from Query Analyzer then its taking 5 seconds but report rendering taking some times 5 to 10 minutes, for output not more than 2 pages. I have just installed Reporting Services 2005 with SQL Server 2005. What are the good practices after installing RS2005 on any box. Is there some performance measures.

Thanks,

Imran.

Imran,

Were you able to find anything on this. We are having a similar problem in our environment SP takes 12 seconds report takes 50 seconds.

Techquest

|||

the issue was with my report, I have dragged and dropped column into group area, and by default it added First function with it, when I removed First function with column name and re-run the report, now its running fine.

No comments:

Post a Comment