We use SQL Server 2000 Reporting Services to represent reports for our company.
Our boss complained to me about the poor performance of Reporting Services when he viewed reports. He suspected that RS Server is a single-thread server and can not be scaled up by adding more CPUs or memories to increase the reports process speed.
Is my boss correct?
And how can we increase the performance of Reporting Servces?
Traditional scale up can resolve the issue?
Appreciate your precious reply.
Your boss is not correct :)
We will scale up with more CPUs. Most of Reporting Services is managed code, so we are subject to whatever memory constraints are in place by the CLR. So on 32-bit machines we will use up to 2GB of memory, and we will use more on 64-bit platforms.
You can check the execution log to see which reports in particular are taking a long time to execute and what phases of those executions are long running:
http://msdn2.microsoft.com/en-us/library/ms159110.aspx
See Tudor's blog entry on performance here as well:
http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx
It has good tips for optimizing a poorly performing report.
|||Excellent!
Thanks alot!
No comments:
Post a Comment