Deleting An SQL Record "Hangs" my application

[Rick_UpperPark]

Edward, I’ve posted a topic with queries I use when dealing with blocking in SQL Server.

Find blocked and blocking sessions in MSSQL

Here are a couple of queries i use extensively while tracking down blocking issues in SQL server. This query shows all the lead blockers. A lead blocker is a session that is blocking other sessions but is not being blocked itself. This query is originally from https://www.sqlservergeeks.com/sql-server-how-to-find-the-lead-blocker-culprit-spid-for-all-blocking/ I’ve modified it to include the database name and host process. /*Show Lead blockers */ SELECT loginame ,hostprocess ,a.s…