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 8:34 am

    #1968787

    How do you know that process is the head blocker?  If it's waiting for a lock then something else must be blocking it.  Do you have sp_whoisactive?

    John