I enabled snapshots in my SQL Server 2016 database, 16 Core CPU, 43 GB memory.
ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE MyDatabase
SET READ_COMMITTED_SNAPSHOT ON
After that, I got deadlock on my database
Transaction (Process ID 69) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I checked the error line number -Delete operation on table
Tables has 7882884 rows with two columns.
Also my stored procedure is running with a begin / end trans block where my table is written
Regards, Manish