We have a busy SSRS Reporting server (SQL Server 2008 R2) on which we see frequent blocking between the below processes:
- [dbo].[CheckSessionLock]
- [dbo].[WriteLockSession]
We are aware that some reports are running unacceptably slow. What I need to know is whether the blocking in the ReportServer database is symptomatic of an overloaded server or whether the blocking is causing the reports to run slow.
I am inclined to believe it is the first case but haven't been able to gather evidence prove it definitively as such.
I have read the thread at https://connect.microsoft.com/SQLServer/feedback/details/698388/blocking-in-ssrs-reportserver-database in which the issue is loosely acknowledged but I cant get to the link cited for addressing this issue.
Has some out there got to the bottom of same problem with blocking in the ReportServer database?