December 21, 2017 at 5:02 am
RSTempFiles directory is filling up our C: drive. Can the files in there be DELETED?
December 21, 2017 at 5:13 am
On our SQL 2012 Enterprise SSRS instance, the DIR C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\RSTempFiles was filling up our 80 GB C: drive w/ 65 GB of RSFILE_xxxxxxx files
As I researched the issue, I found that this DIR acts a little bit like a SWAP file in Windows.. Large SSRS data requests can house data inside this DIR temporarily. I searched high and low for resolution to clear out this DIR (several files named RSFILE_xxxxxxxx) At least one post suggested you do not touch these files as DELETING them could corrupt your installation.
Anyway, after about 45 mins of research, I returned to view the RSTempFiles directory once again ---- AND all of a sudden, it returned to just a few hundred MB used; the very large files beginning w/ RSFILE_xxxxx were GONE! I believe a CLEANUP process initiated and deleted the large files.
If anyone knows the name of the CLEANUP process and would like to reply to this thread with where it resides and "how to set it's cleanup frequency", it would be helpful.
January 5, 2018 at 6:22 am
Have a look at the FileShareStorageLocation parameter
You can tell SSRS to store the temp/swapfiles somewhere else
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply