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 #422: Search faster by searching less

Ultimate search

I’d like to be able to search contacts by first name and last name. And middle name. And birthday. And employee id. While you’re at it, add spouse name, comments, city, country, phone number (all of them) and freight terms. So, what a smart CRM consultant to do? Open Quick Find Active Contacts view and […]

Tip #267: If form load is slow, take this pill

IIS 8 performance settings

Gayan “Not Daddy” Perera is a man of few words when it comes to squeezing the last bit of performance out of on-premise installations. Succulent and straight to the point: If you’re running CRM 2013 on-premise using IIS 8, make sure to go into the IIS Manager > Configuration Editor then select system.web\caching\outputCaching, set omitVaryStar […]

Tip #225: When CRM makes ye say “Arrrrrrgh!”

Friday, September 19 International Talk Like a Pirate Day 2014 If ye be usin’ Dynamics C Arrrrrrrrrrrr M fer several years, ye may spy wit’ ye eye that CRM starts runnin’ like a scallywag. Here be several thin’s ye can do to swab th’ deck ‘o ye CRM system, hoist performance, ‘n spit shine th’ cobwebs […]

Tip #215: Computer says ‘no’

Well, this is embarrassing. Remember that flogging I unleashed on unscrupulous developers being disrespectful to LINQ, performance and humanity in general? I was basking in my own cleverness of possessing the knowledge of LINQ operators including magic Any: Yesterday I had a chance to use what I preached and this is what I got in […]

Tip #212: Getting a yes or no answer in LINQ

Say, you need to find out if your organization has any opportunities with the estimated value of more than a million dollars (that’s right, that’s how developers usually roll). No need to retrieve anything, just simple yes or no. There are many ways to accomplish the task, most of them, sadly, are as efficient as […]

Tip #171: If email router is having a slow day or how to add custom index

Sometimes things are slow. Very. Slow. So slow that your email router starts spitting dreadful messages: #9628 – An error occurred while delivering the e-mail message with subject “None of your business” in mailbox foo@bar.baz for delivery to https://crm.bar.baz. System.ServiceModel.FaultException`1 [Microsoft.Xrm.Sdk.OrganizationServiceFault]: SQL timeout expired. (Fault Detail is equal to Microsoft.Xrm.Sdk.OrganizationServiceFault). If you are on CRM […]