I just returned from having several in-person discussions this week with customers, DBAs and developers who were looking for guidance, best practices and whitepapers on scaling SQL Server Reporting Services (SSRS) 2205 & SSRS 2008. I compiled what I feel are the best publicly available postings from Microsoft’s internal SQL CAT & product teams for each of these areas below … enjoy! Best, Mark
- Scale-out for both SSRS 2005 & SSRS 2008. You will find a link in there to report catalog (metadata) DB best practices as well as suggestions for load balancing.
- When you read this article on lessons learned from scaling UP a SSRS 2005 instance, you will see that SSRS 2008’s updated architecture of using the HTTP listener and not requiring IIS and other improvements make SSRS 2008 MUCH more scalable.
- And, finally, how to monitor performance and review individual report designs