SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back?
In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.
by David Leibowitz
April 8, 2008
ne of the largest changes in SQL Server 2008 Reporting Services (SSRS) is that it no longer relies on
IIS. Due mostly to feedback from end users on security (most do not like to keep web hosts active on their database
servers), the added benefits include reduced memory requirements and service spool-up time.
Testing the Performance of Requests
The tests used for this article were designed to time the performance of requests against the Reporting Service web service
(ReportServer2005.asmx). Report rendering and data retrieval was not tested.
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
ne of the largest changes in SQL Server 2008 Reporting Services (SSRS) is that it no longer relies on
IIS. Due mostly to feedback from end users on security (most do not like to keep web hosts active on their database
servers), the added benefits include reduced memory requirements and service spool-up time.
