I have been doing performance analysis for SSRS 2008 for some really huge reports that return between 1 to 5 million records (with single user) and
reports that return 100K to 200K records with multiple users. I have observed lot of issues which made me to think that may be SSRS 2008 is not good enough for such a huge reports even less good if there is a multiple users scenario for those big reports(though
I wanted to use it). Please go through my points and share your views on this.
Before putting up the points I would like to mention my configuration, Windows Server 2003 Enterprise Edition R2 SP2 64 bit (totally dedicated to
SSRS reports as the data source for these reports was SQL Server 2005 Enterprise Edition), Microsoft Reporting Services 2008 R2 64 bit, 8 CPU, 8 GB RAM and the reports are simple tabular reports which are fetching the data from a single table (no joins)
View Complete Post