Tip #606: Be careful with WAN optimization

If your network magicians deployed either a hardware or a software WAN Optimizer, here is a word of advice from Gayan “Performance Wizard” Perera, presumably learned the hard way: If you have a WAN Optimizer on your network and it’s trying to optimize CRM traffic, double check the following settings because it can affect CRM […]

Tip #302: Optimize CRM by updating statistics and reorganizing indexes

Another SQL nugget from Gayan “Mr Performance” Perera: If you’re running CRM (any variant) on-premise you can optimize the speed of the system by setting up two management jobs inside SQL. First, update statistics of the organization_MSCRM database every day (outside business hours). Second is to reorganize the indexes of the organization_MSCRM database every 2-4 […]

Tip #216: In a parallel dimension

I’ve had the following discussion with two different CRM administrators in the past week. We’ll call them “Larry.” Larry: “My CRM organization is very slow. I try to search for records and it takes 25 seconds. I tried to import an organization, and it took 25 hours to complete.” Me: “What is your Max Degrees of Parallelism setting in […]