Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2011-05-06 : 07:47:41
|
| 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 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2011-05-06 : 08:55:53
|
| I found my answer, SSRS caches reports on ReportServerTempDB on the harddrive. So, I guess storage could be a concern if there was a lot of activity! That's another issue though. |
 |
|
|
|
|
|
Caching a lot of reports...