Configuring the Microsoft SQL Server Content Data Store
Prevent deadlocks by swtiching on snapshot isolation.
Procedure
Run the following SQL commands on your Content Data Store database:
ALTER DATABASE DBName SET_ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE DBName SET_READ_COMMITTED_SNAPSHOT ON
EXEC SP_UPDATESTATS