Performance Tuning Crm Async Service
Deploy Asynchronous Service on Separate Server
1. Login to Server as Domain Administrator.
2. Locate the CRM 2011 installation media and execute SetupServer.exe and then proceed through the wizard, making note of the following sections:
a) On the Specify Server Role page, ensure that only Asynchronous Processing Service role is selected to install.
b) On the Specify Deployment Options page, in the Enter or select the name of the computer that is running SQL Server to use with the deployment, enter the SQL database (virtual) server name and select Connect to, and if necessary, upgrade an existing deployment.
c) On the Specify Security Accounts page, for the Asynchronous Service, choose the CRMAsyncSvc account.
d) On the Select Microsoft Update Preference page, choose I don’t want to use Microsoft Update. Updates to the production-hosted platform should be strictly controlled and only applied after:
i. approved by Microsoft for deployment in a hosting environment ii. validated in a test environment
e) Complete the installation wizard.
3. Repeat the preceding on all additional CRM Asynchronous Processing Back-end servers in the deployment group.
Ref: http://technet.microsoft.com/en-us/library/gg197607.aspx
Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM
When you run Microsoft Dynamics CRM 4.0 or Microsoft Dynamics CRM 2011, the AsyncOperationBase table grows to be very large. When the table contains millions of records, performance is slow.
Kindly visit this KB article ( http://support.microsoft.com/kb/968520 ) from Microsoft for more detail.
Reducing the Number of Active Workflows in Memory
If you are having a heavy load on the CRMASyncService due to the amount of workflows in combination with a relatively small server, then you'll need to change default settings of CRM to make sure that your system will remain active.
The default settings for workflow are set to a minimum of 1000 active workflows and
1. Login to Server as Domain Administrator.
2. Locate the CRM 2011 installation media and execute SetupServer.exe and then proceed through the wizard, making note of the following sections:
a) On the Specify Server Role page, ensure that only Asynchronous Processing Service role is selected to install.
b) On the Specify Deployment Options page, in the Enter or select the name of the computer that is running SQL Server to use with the deployment, enter the SQL database (virtual) server name and select Connect to, and if necessary, upgrade an existing deployment.
c) On the Specify Security Accounts page, for the Asynchronous Service, choose the CRMAsyncSvc account.
d) On the Select Microsoft Update Preference page, choose I don’t want to use Microsoft Update. Updates to the production-hosted platform should be strictly controlled and only applied after:
i. approved by Microsoft for deployment in a hosting environment ii. validated in a test environment
e) Complete the installation wizard.
3. Repeat the preceding on all additional CRM Asynchronous Processing Back-end servers in the deployment group.
Ref: http://technet.microsoft.com/en-us/library/gg197607.aspx
Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM
When you run Microsoft Dynamics CRM 4.0 or Microsoft Dynamics CRM 2011, the AsyncOperationBase table grows to be very large. When the table contains millions of records, performance is slow.
Kindly visit this KB article ( http://support.microsoft.com/kb/968520 ) from Microsoft for more detail.
Reducing the Number of Active Workflows in Memory
If you are having a heavy load on the CRMASyncService due to the amount of workflows in combination with a relatively small server, then you'll need to change default settings of CRM to make sure that your system will remain active.
The default settings for workflow are set to a minimum of 1000 active workflows and