Tips to Improve Performance in Different Layer of MSCRM
1 Database layer 1.1 Indexes A database index is a data structure that improves the speed of operations in a table. Description : Maintaining indexes is a key factor in achieving minimum disk I/O for all database queries. The database maintenance command ALTER INDEX can help in defragmenting indexes in Microsoft SQL Server® and in rebuilding one or more indexes for a specific table. Current Scenario: All indexes are configured as per CRM system out of box feature. We need to find if there any requirement for the new indexes by the usage. Solution : · Use SQL Server Profiler to record usage. Analyze recorded usage in the DBA Dashboard tools. · Individual Queries can also be analyzed by the Database Engine Tuning Advisor. · Use SQL profiler traces with ...