Search code examples
sql-serversql-server-2016

Getting DeadLock in SQL Server even after restarting server

I am getting deadlock error when updating a table :

Transaction (Process ID 67) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

All other works perfectly fine. The thing making me uncomfortable is I have restarted the server itself 4-5 times how is the dead lock still on table.

Any suggestions?

Solution

  • Transaction (Process ID 67) was deadlocked on lock | communication buffer resources

    This is probably caused by a bug while running a parallel query. Upgrade SQL Server to a later version, or disable parallelism for this query or the whole server.