Snapshot on, still deadlocks in SQL Server

728 views Asked by At

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

0

There are 0 answers