Reportserver database causing blocking

• gary1

  SSC-Insane

  Points: 21152

  More actions

  March 1, 2012 at 10:40 am

  #251637

  Hi,

  I'm seeing blocking by the procedure WriteLockSession in ReportServerTempDB

  I have verified the reportserver logs and there are errors.

  I did not find any clue why this is occurring. Please see the attachment for blocking sessions

  CREATE PROCEDURE [dbo].[WriteLockSession]

  @SessionID as varchar(32)

  AS

  INSERT INTO [ReportServerTempDB].dbo.SessionLock WITH (ROWLOCK) (SessionID) VALUES (@SessionID

  CREATE PROCEDURE [dbo].[CheckSessionLock]

  @SessionID as varchar(32)

  AS

  DECLARE @Selected nvarchar(32)

  SELECT @Selected=SessionID FROM [ReportServerTempDB].dbo.SessionLock WITH (ROWLOCK) WHERE SessionID = @SessionID

  Thanks

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  March 1, 2012 at 11:18 am

  #1453796

  Reporting services does this periodically. I'm not sure what can be done to resolve it.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• sengeet86

  Ten Centuries

  Points: 1252

  More actions

  March 1, 2012 at 11:52 am

  #1453815

  I am also seeing this but this reportserver blocks got auto cleared in sometimes.

  java programming