Monthly Archives: December 2011

2 Dynamics CRM 4.0-2011 Upgrade Tip #6: Clean up deleted records

Full disclosure: I am blatantly stealing this idea from Joel Lindstrom at Customer Effective, as outlined in this article: Preparing for CRM 2011: How to Make your Microsoft Dynamics CRM 2011 Upgrade Faster Run the deletion service. In CRM 4.0, if you deleted records, the records were not immediately deleted-they were flagged for deletion, then […]

Continue reading

1 Dynamics CRM 4.0-2011 Upgrade Tip #5: Remove unsupported database changes

As you used your Dynamics CRM 4.0 database you may have had occasion to add "unsupported" objects to the database.  These could be anything from indexes ( fairly supported ) to triggers ( pretty unsupported ) to custom stored procedures. You need to consider removing all of these additions prior to the upgrade. The pre-upgrade […]

Continue reading

1 Dynamics CRM 4.0-2011 Upgrade Tip #4: Clean up old Synch table entries

If you are using the CRM Outlook client you will find two sets of tables in the CRM database beginning with: SubscriptionStatistics and SyncEntry. Like the AsyncOperationsBase table containing old and useless information, these tables present the same sorts of issues. Luckily, the Microsoft UK Dynamics Support team has an answer: Script to clean up […]

Continue reading

1 Dynamics CRM 4.0-2011 Upgrade Tip #3: Clean up the System Job and Workflow Job Tables

In CRM 4.0 the system jobs table, otherwise known as the AsyncOperationsBase table, could expand to the point that normal CRM operations were affected.  That’s a worse-case scenario. Regardless of current system performance, an abnormally large number of records in this table can slow down the upgrade process.  Since we want our upgrade to go […]

Continue reading