Microsoft Dynamics CRM 4.0 performance optimization 2

Use Snapshot isolation to improve system performance.

Start Snapshot isolation. this function is available in sql2005. you can use the following connection to find out what is Snapshot isolation and how to do it. starting Snapshot isolation can improve your performance and solve some resource locking problems to varying degrees.

Refer:

Http://msdn.microsoft.com/zh-cn/library/tcbchxcb (vs.80). aspx

Http://msdn.microsoft.com/en-us/library/tcbchxcb (vs.80). aspx

The procedure is as follows:

1) Stop IIS on the CRM Server

2) Stop the CRM asynchronous service Microsoft Dynamics CRM async Service

3) Back up your database. <myorg_mscrm> and mscrm_config

4) Open SQL Server Management studio and run the following code:

Alter database <myorg_mscrm>

Set allow_snapshot_isolation on

Alter database <myorg_mscrm>

Set read_committed_snapshot on

 

Alter database mscrm_config

Set allow_snapshot_isolation on

Alter database mscrm_config

Set read_committed_snapshot on

 

Note: The <myorg_mscrm> label varies depending on the organization name. If the CRM organization name is Amos, replace the label with amos_mscrm.