Break the Shackles of your CRM Environment!

Hi Looking for a data management solution in CRM? Every body knows, if active data load is less, the transactions will process faster. But probably the purging policy of customer for data may not allow you to remove or delete history data. :-( May be you will reach some situation where we cannot achieve better performance after doing all technical/hardware changes in CRM and infrastructure level. In  such situation, this approach may help you. Here is the basic idea.  Below items has to take care: 1.        Keep the same GUID & Created on dates for integrity 2.         Sync Customization Changes in Original entity to duplicate Entity I    We are in the process of making this tool. I will post as per its progress.... Welcome your input             Thanks. Great Day Ahead!

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 ...