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 |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2012-01-06 : 13:50:17
|
| The root of my RSTempFiles folder has grown from almost nothing to larger than 50 GB twice now. The root of the folder has files (starting with "RSFile_") that suddenly grow and grow during the night and in the morning the server is unusable. My RSReportServer.config file has WebServiceUseFileShareStorage set to False though!? How do I stop this?? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-06 : 14:35:37
|
| have you enabled snapshot options for some reports? I think it may be these historical snapshots which are getting stored in it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2012-01-06 : 15:29:51
|
| I have, yes. I will try to test that, thanks! |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2012-01-06 : 16:17:12
|
Actually wait, is caching a temporary copy of a report (under Processing Options) the same as using snapshots? If not, could the caching I'm doing be causing the files to show up in RSTempFiles?I think this might be what the files are, but I don't know how to stop them from growing uncontrollably:quote:
Output/Intermediate Streams These files are all created directly within the the RSTempFiles directory. There is no way to differentiate between these two sub-categories of files currently. Output streams - these streams are generated as output from the renderers. The server spools them to disk if they grow large enough. RS has an output cache that may cause these streams to survive beyond the lifetime of the request so that subsequent accesses can be served directly from the cache. Intermediate files - these files contain results of intermediate calculations during report processing and rendering. Generally, these contain data which is never returned to the client, but rather holds temporary results in order to relieve memory pressure. These files are cleaned up when the request completes (no caching across requests).
http://blogs.msdn.com/b/jgalla/archive/2008/06/30/all-those-temporary-files-rstempfiles.aspx |
|
|
|
|
|
|
RSTempFiles folder filling up