SQL Server Performance

SQL Server Reporting Services - Do you cache popular reports for better performance?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jan 7, 2008.

  1. Anonymous New Member

    Do you cache or not? By default SQL Server cache stores the data &amp; query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required to retrieve a report if the report is large or accessed frequently. Bear in mind that If that server is rebooted, all cached instances are reinstated when the Report Server Web service comes back online that means all the cached reports will be disappeared....(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/01/07/sql-server-reporting-services-do-you-cache-popular-reports-for-better-performance.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3120" width="1" height="1">

Share This Page