All historical data in CRM is used to reporting purpose only.
Microsoft Dynamics CRM 3.0 does not provide any data achieving functionality 
and therefore the database size increased rapidly which results in a very 
slow performance.
I Think Microsoft should provide this functionality to CRM Administrator to 
archive the old data in a wizard based interface or should provide a way to 
CRM Administrators/DBAs to implement it using SQL Server Table Partitioning 
functionality introduced in SQL Server 2005 on the CRM Databases. 


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the 
suggestions with the most votes. To vote for this suggestion, click the "I 
Agree" button in the message pane. If you do not see the button, follow this 
link to open the suggestion in the Microsoft Web-based Newsreader and then 
click "I Agree" in the message pane.

http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=a27b6372-db75-454a-becb-961f8d5117b1&dg=microsoft.public.crm