Home Snapshot on, still deadlocks in SQL Server
Reply: 0

Snapshot on, still deadlocks in SQL Server

MANISH
1#
MANISH Published in 2017-11-18 10:04:06Z

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

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.333296 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO