Optimizing Microsoft CRM 1.2 Performance White Paper

In October 2004, Microsoft published this 53 page white paper titled "Optimizing the Performance of Microsoft CRM 1.2" discussing how to optimize the performance of your Microsoft Business Solutions CRM 1.2 system. You'll learn how reindexing database indexes, enabling the Microsoft SQL Server text in row option, and regularly maintaining your databases can increase the speed with which Microsoft CRM accesses your data. More advanced techniques, such as improving report performance are included; as well as links to performance enhancements and security updates. You'll also find complete SQL scripts that you can copy and use immediately. Download White Paper Now (308 KB) The paper begins with several optimizations that have the potential to increase performance the most and are also relatively easy to perform. The optimizations later in this paper can also improve performance, but are more complex, and require more advanced knowledge to complete. To enhance performance of Microsoft CRM the most, try these optimizations in the following order:   1. Reindex the Microsoft CRM database using the DBREINDEX script   2. Enable the Microsoft SQL Server Text in Row option   3. Maintain the database regularly - Updating Statistics - Disabling Data Replication - Reduce the Size of the Database Table - Remove Records Deleted from Microsoft CRM - Creating and Managing Indexes   The following optimizations are also useful, but they might not provide as much benefit to Microsoft CRM performance, or might require more advanced knowledge to implement:     4. Performance Enhancement and Security Updates - Cumulative Security Update for SQL Server 2000 - Applying the Performance Enhancement Update - Improving Synchronization Performance - Fixing the Error That Occurred When Copying a Role in Microsoft CRM 1.2   5. Configure Microsoft CRM   6. Manipulate file groups   7. Improve report performance   8. Monitor performance of Microsoft CRM system - Performance Monitoring for Windows 2000 and Windows Server 2003 - Performance Monitoring of the IIS Server - Performance Monitoring of Exchange 2000 and Exchange 2003 - Performance Monitoring of SQL Server 2000 - .NET Framework Tuning Important: These optimizations are based on a standard Microsoft CRM 1.2 configuration. Due to the many types of customized configurations available to Microsoft CRM 1.2 customers, the optimizations may or may not work with all configurations. Warning: Before performing any of the following optimization procedures, back up your databases and Active Directory. If you do not back up these items, you risk losing the information contained in them.