Performance Issue with Firewall in the middle between CRM and Database Server
-
Wednesday, February 13, 2008 12:59 AM
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
All Replies
-
Wednesday, February 13, 2008 12:59 PMModerator
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 1:25 PMHi 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.
