Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Head blocker - Sleeping process with select command on empty table RE: Head blocker - Sleeping process with select command on empty table

  • November 20, 2017 at 9:09 am

    #1968799

    That session has an open transaction. The column 'open tran count' shows 1, so open transaction, holding locks until commit/rollback. That's why it's blocking other sessions.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass