Reducing deadlock errors in Microsoft SQL Server
High Microsoft SQL Server concurrency causes transaction deadlock errors because writers block access, by readers, to
database resources. You can reduce the likelihood of deadlock by setting the
READ_COMMITTED_SNAPSHOT ON option for your database.