Post reply

Blocking in report server database and changing isolation levels

  • October 12, 2015 at 2:18 pm

    #321447

    Hi,

    We are getting frequently blocking in Report server database.

    Is it ok to change isolation level to RCSI for report server database?

  • October 13, 2015 at 2:35 am

    #1832921

    You probably have very slow running queries in your repository database. I would look to performance tune rather than look to change ISOLATION Levels which I don’t believe will help here.

  • May 2, 2019 at 1:11 pm

    #3627170

    Did you ever get a real answer on this? I'm experiencing blocking issues on ReportServer database too (no it's NOT slow running queries - it is verifiable blocking). Id like to enable RCSI too but cant find any guidance from MS as to whether its supported or not.

  • May 2, 2019 at 7:33 pm

    #3631495

    I don't remember reading anything about RCSI, just that you can't enable snapshot isolation on the report server database.

    But if the blocking is related to session data - such as the session tables or GetSessionData, WriteLockSession - that is one of those behaviors listed as "by design". They are typically related to long running reports and other alternatives are recommended.

     

    Sue

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply