SQL Head Block not being released
Posted on 2010-08-13
First let me apologize if this has been asked before.
We have a database we are experiencing some major locking issues with. We noticed some long wait times and a large number of waiting tasks. Upon following the session IDs all the way back to the head blocking session ID that session ID is still marked as the head block, but has no SQL Command associated with it. The only thing associated with the session is "SET TRANSACTION ISOLATION LEVEL READ COMMITTED"
Our web application is Cold Fusion Based hitting a SQL Server 2008 Server.
Please let me know where to look and what to look for.
Thanks in advance.