October 12, 2015 at 2:18 pm
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
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
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
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