SSRS WriteLockSession holding open transactions

32505975 31 Reputation points
2021-01-28T11:39:15.237+00:00

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

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?

Regards,

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 38,461 Reputation points
    2021-01-29T02:32:21.067+00:00

    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.

    Regards,

    Zoe


    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


Your answer

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