Should I maintain indexes on SSRS ReportServerTempDb (SSRS 2016)

32505975 26 Reputation points
2021-01-06T14:51:29.933+00:00

Good afternoon,

I had an issue this morning where a WriteLockSession stored procedure seemed to have frozen/got stuck (it had been running for around a day)... some index maintainence task then fired off against the ReportServerTempdb.dbo.SessionLock table and got stuck behind this frozen process.
This in turn escalated and caused blocks against further "WriteLockSession" procedures for other reports.

My question is this:
Should I be maintaining indexes against the ReportServerTempDb database or not?

If i wasnt performing this maintenance, then the issue wouldnt have occurred. Conversely, I worry that performance on this system may degrade over time as it is a highly changing table.

Thanks

ANdy

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.
2,801 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-01-07T06:09:11.54+00:00

    Hi anonymous userBassitt-2146 ，
    ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports.
    You don't need to maintain this database. It would affect the performance of SSRS server overtime.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Joyzhao-MSFT 15,566 Reputation points
    2021-01-08T06:57:51.877+00:00

    Hi anonymous userBassitt-2146 ，
    Has your issue been resolved?
    If you have any question, please feel free to let me know.
    If the answer is helpful, please click "Accept Answer" and upvote it.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments