Deadlocks in MSCRM database
To avoid dead locks in MSCRM database, MS suggests two settings to be done. • Enable Read Committed Snapshot Isolation Level Go ALTER DATABASE Org_MSCRM SET READ_COMMITTED_SNAPSHOT ON Go SET TRANSACTION ISOLATION LEVEL SNAPSHOT Go • Set ‘Max Degree of Parallelism’ to 1 Set the Max Degree of Parallelism to improve performance which will improve query execution for CRM because any given query will only use one processor for execution and will prevent unnecessary blocking from taking place.