If you want to do a quick and simple exercise to view blocking transactions on your SQL Server machine (code at bottom of blog).
I create a dummy table called “BlockingTable” and insert 10 rows of data. I then open a transaction and doing a simple update of the table. I leave the transaction open and open three new sessions. Continue reading “Use sys.dm_os_waiting_tasks to Find Blocking Transactions”