September 2, 2015 at 4:15 pm
We frequently see blocking on our SSRS box which houses both front-end Report Manager ReportingService and the SQL database engine with ReportServer & ReportServerTempDB Catalog databases
Blocking session:
Database name: ReportServer
Application name: Report Server
Host name: SSRS01
OS User name: SYSTEM
Database User name: NT AUTHORITY\SYSTEM
First 2KB of SQL: CREATE PROCEDURE [dbo].[CheckSessionLock] @SessionID as varchar(32), @LockVersion int OUTPUT AS DECLARE @Selected nvarchar(32) SELECT @Selected=SessionID, @LockVersion = LockVersion FROM [ReportServerTempDB].dbo.SessionLock WITH (ROWLOCK) WHERE SessionID = @SessionID
Blocked session:
Database name: ReportServer
Application name: Report Server
Host name: SSRS01
OS User name: SYSTEM
Database User name: NT AUTHORITY\SYSTEM
First 2KB of SQL: CREATE PROCEDURE [dbo].[CheckSessionLock] @SessionID as varchar(32), @LockVersion int OUTPUT AS DECLARE @Selected nvarchar(32) SELECT @Selected=SessionID, @LockVersion = LockVersion FROM [ReportServerTempDB].dbo.SessionLock WITH (ROWLOCK) WHERE SessionID = @SessionID
Anyone else experience this, and fix it ?
September 2, 2015 at 11:00 pm
I don't think this is part of SSRS. It seems like it's done by whatever monitoring software you use.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply