SSRS WriteLockSession holding open transactions

32505975 26 Reputation points

Good morning,
We are noticing that on our SQL 2016 SSRS box that we are periodically having some transactions which sit open indefinitely.

It appears that the WriteLockSession is opening, but not closing. (See above image). This doesnt seem to happen for EVERY instance, but only occasionally.

Is this normal behaviour as this is causing our indexing tasks on ReportServer to get stuck and cause blocks.

If this is abnormal, is there a workaround for this?



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,818 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,386 Reputation points

    Hi @32505975 ,

    Welcome to Microsoft Q&A.

    It seems that the issue has been resolved by yourself.

    You may click 'Accept Answer' on your reply.

    So that we could achieve the case and it will be helpful to those who are also encountering this issue.



    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.
    Hot issues October