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 #221: Lobachevskian geometry

When things get out of control in a parallel universe, people notice and intervene. As turned out to be the case. One comment from Chad Rexin was so good that it deserved its own post. Welcome to the twisted SQL world where, like in Lobachevskian geometry, there is more than one degree of parallelism. Another […]

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 […]