SQL Server 2008, Tempdb ("ReportServerTempDB")of the report server is growing enormously over 20gb in 3 days. All our reports drive from  stored procedures which is a different server from Reportservertempdb. We have no report subscriptions. We store no snapshots. All we do is run the reports.

I don't know where I start to investigate the issue. Please help. Thanks in ad

Hi czarvk,

According to your description, the report server temporary database is growing large, right?

In Reporting Services, 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.

In your scenario, one cause of the issue is that the cleanup cycle is not executing as expected. For more information, please refer to this article: ReportServerTempDB growing large : One of the causes.

Besides, you can query out all the large tables in report server temporary database, then stop reporting services, truncate those large tables and shrink the database. Please refer to this similar thread: ReportServerTempDB at over 60 GB size - is it safe to truncate the Segment table?.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Hi czarvk,

What is the number of user accessing the reports ? There was a similar issue as of yours.Please check the below link

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2fcf6ed6-2d0f-4df0-93d3-992bb3b44ef4/reportservertempdb-grows-unexpected