Monday, December 8, 2008

CRM Client for Outlook Performance tweaks

One of the most common complaints I get from clients that use the CRM for Outlook add-in is that "It takes forever to open" or "It makes my outlook run slow!". Many of the performance problems that are actually related to the CRM add-in were fixed individually with a hotfix or more recently fixed in rollup 1 which was released late last month. (And can be downloaded here)

Most of the speed problems are Outlook issues and can be resolved a number of different ways. Before I begin, let me explain the difference between a .pst and an .ost. If you are using outlook to download e-mail from your e-mail provider via pop3, IMAP or some other service, you are most likely storing your e-mail in a .pst (personal store). If you connect to an exchange server to get your mail, you most likely running in cached exchange mode and have an .ost. The .ost is just a cached version of what is stored for you on the exchange server but is located on your hard drive similar to a .pst. Now that that is out of the way, lets move on to the actual tweaks.

1) The enhancement that I find gives me the most bang for the buck (this is for Outlook 2007 users) is to rename the extend.dat file under the individual user's profile. On XP this is located in c:\documents and settings\\Local Settings\Application Data\Microsoft\Outlook and in a similar location on Vista under the c:\users directory. Renaming another file, FRMCACHE.DAT located here: C:\Documents and Settings\\Local Settings\Application Data\Microsoft\FORMS has also been known to improve outlook startup and response times.

2) The way I understand it, Outlook loads its data store into memory at startup. If you have a lot of e-mail, this can decrease the performance of Outlook significantly. Archiving e-mail into a separate .pst file or deleting old e-mail can help performance.

3) Prior to outlook 2003, .pst's and ost's could not exceed 2GB's. In 2003 and later this issue was fixed but for many users, outlook performance decreases significantly when the .pst and .ost sizes reach the 2GB and greater mark. If your .ost file is larger than 2GB, try archiving old e-mail into a local store (.pst). OST's do not shrink in size once data has been removed so if you recently deleted a large quantity of mail and noticed that your .ost hasn't shrunk in size, you can fix this by renaming the .ost file (with outlook closed). When outlook opens again it will connect to the exchange server and re-create the .ost file using a more appropriate size.

Friday, December 5, 2008

Crm 4.0 Rollup 1 and CRM's Auto-Update Feature

With the first roll-up now available for CRM 4.0, I'm sure there are administrator's out there dreading deploying the client patch on each and every afflicted computer. I just wanted to take a moment to uncover a post from the Microsoft Team blog that could save you a lot of trouble in the future: https://community.dynamics.com/blogs/cscrmblog/archive/2008/05/08/crm-client-autoupdate.aspx

Essentially it outlines how to set up the auto-update functionality in the outlook client from the server. It does mention that you need to add a key to the registry of each computer that has CRM but remember you can easily deploy the key via netlogon scripts deployed using active directory.