Sign in

Microsoft.com

Microsoft

Remove From My Forums

Performance Issue with Firewall in the middle between CRM and Database Server

Question
0

Sign in to vote

Hi,

Apologize for cross posting.

Please consider this Intranet deployment. Please notice that this deployment is intranet deployment and not Internet Facing Deployment. The CRM server cannot be accessed on the internet.

Client Browser -> CRM Server -> Firewall -> SQL / Database Server

The common practice in the live production is placing the database server inside the firewall. I would like to know whether there’s a performance issue if the CRM Server needs to connect to the database server through the firewall.

I am very concerned that the firewall will disconnect any idle connection within certain timeframe, so it might disturb the user’s activities when browsing the CRM application.

Thanks for the reply.

Regards,

Hadi Teo

Wednesday, February 13, 2008 12:59 AM

All replies

0

Sign in to vote

Dear Hadi,

The performance of your CRM implementation is one of the key factors for customer acceptance. There are multiple options available for optimizing your system. Here's a list to get started:

Microsoft - Optimize Microsoft Dynamics CRM 3.0

Microsoft - Optimize Microsoft Dynamics CRM 1.2

Aaron Elder - Optimize the CRM Webservice Calls

Brein Reid - Reduce the amount of useless calls to IIS 6.0 Applications for optimal Performance

Some more tips:
- Do NOT virtualize your SQL Server.
- Run CRM from a computer with a physical network connection instead of wireless.
- In your code use as least webservice calls as posssible.
- Look in the implementation guide on how to cluster your SQL Server and/or load balance your webserver.
- If requirements allow you to do so, run the callout code asynchronous. In the callout just create an MSMQ message and create a windows service which listens to this MSMQ and execute the code.
- In imports and migrations, try to disable as many workflows and callouts as possible.

Regards,

Imran

http://microsoftcrm3.blogspot.com

Wednesday, February 13, 2008 12:59 PM

Moderator
0

Sign in to vote

Hi Imran,

Thanks for your reply. The reply didn't seem to address the issue of the firewall. I am expecting like what are the detail configurations of the firewall in order to deploy the CRM solutions.

Regards,

Hadi Teo.

Wednesday, February 13, 2008 1:25 PM