Share via

Sql Server Reporting Services 2016 blocking and slow

Jay Johnson 25 Reputation points
2023-12-07T20:41:16.1+00:00

SSRS 2016. Noticing lots of blocking happening in ssrs databases. Procedures involved: Writelocksession, createchunksegment, readchunksegment, cleanorphansnapshots, The segmentedchunk,chunksegmentmapping, and segment table in ssrs tempdb are huge. Is it problematic for these tables to be large? Is there a safe process to clear these tables?

SQL Server Reporting Services
SQL Server Reporting Services

A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.

Answer accepted by question author

Anonymous
2023-12-08T02:14:34.23+00:00

Hi @Jay Johnson

According to the Report Server Database documentation:

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. Generally, it is safe to delete the contents of the temporary database at any time. However, you must restart the Report Server Windows service after you delete the contents.

For cleaning up ReportServerTempdb, you can refer to this thread: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/333cff93-46b3-4e94-93aa-164963cafd18/cleaning-up-reportservertempdb-segment-and-related-tables?forum=sqlreportingservices.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya

Was this answer helpful?

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.