Dead lock

[SqlException (0x80131904): Transaction (Process ID 109) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]

You can see that error when deadlock happen. I find some use full link that might help you to resolve that issue

1- means on 0- means off
SELECT is_read_committed_snapshot_on FROM sys.databases
WHERE name= 'DATABASE Name'

https://www.youtube.com/watch?v=9NVu17LjPSA
https://www.youtube.com/watch?v=9NVu17LjPSA


https://goo.gl/c5ryq7
https://goo.gl/8JpFwD

https://goo.gl/p4hQ1e
ALTER DATABASE generic SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE