Post reply

Blocking frequently reportServerTempdb

  • August 27, 2015 at 3:46 pm

    #302681

    Hi,

    I need any help to solve the below blocking issue

    One of our production server is configured with Always on with sql cluster.

    We are getting frequently blocking

    Waiting Resource Key Type: Key

    WaitType: LCK_M_S

    WaitResourceDatabaseName : ReportServerTempDB

    WaitingSessionProgramName: Report Server

    BlockingSessionProgramName: Report Server

    WaitCommandType: Select

    WaitingCommandText: Create Procedure dbo.checksessionLoak @sessionID...

  • August 27, 2015 at 4:42 pm

    #1822944

    How can we help you with so little information? No code for the stored procedure, no code actually doing the blocking, object that is blocked, other code requesting the lock it can't get, no table definitions, execution plans, etc., etc.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 2 posts - 1 through 1 (of 1 total)

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