I have a stored proc which is being called from asp.net clients. My SQL 2008 is beefy 32GB 16 processors 64 bit (AMD) running Win2008, still getting deadlocks.
I use Begin and commit Tran in my procedure, there are some selects inserts and updates and deletes in the procedure.
How do I fix it?
Error Detail: System.Data.SqlClient.SqlException: Transaction (Process ID 133) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
View Complete Post