Hi there, I have a report that a parameter with 91 different selections. I want to cache the report for performance and so have created a data-driven-subscription to cache all 91 reports -based on 91 different parameter choices. I'm concerned that I'll use memory I don't have on the server (which is only 4GB). I'm also a little confused how SSRS caches reports. I've read that ReportServerTempDB stores snapshot data. Is this all data that's fetched from the queries or just meta-data? Does this include cached data? Or, does SSRS actually use the physical memory to store the query data and report meta-data as well? Any help in clarifying this for me would be much appreciated:) Thanks

(http://msdn.microsoft.com/en-us/library/ms155927.aspx) From books Online: Note Reporting Services stores temporary files in a database to support user sessions and report processing. These files are cached for internal use and to support a consistent viewing experience during a single browser session. For more information about how internal-use temporary files are cached, see Report Server Database(http://msdn.microsoft.com/en-us/library/ms156016.aspx). And: Each report server database uses a related temporary database to store session and execution data, cached reports, and work tables that are generated by the report server. Background server processes will periodically remove older and unused items from the tables in the temporary database. The cached reports are stored in the database. So on the hard drive.

From books Online: Note Reporting Services stores temporary files in a database to support user sessions and report processing. These files are cached for internal use and to support a consistent viewing experience during a single browser session. For more information about how internal-use temporary files are cached, see Report Server Database(http://msdn.microsoft.com/en-us/library/ms156016.aspx). http://msdn.microsoft.com/en-us/library/ms155927.aspx And: Each report server database uses a related temporary database to store session and execution data, cached reports, and work tables that are generated by the report server. Background server processes will periodically remove older and unused items from the tables in the temporary database. The cached reports are stored in the database. So on the hard drive.

@Ferry, Thanks for that clarification... I'll read the articles also