Microsoft dynamics crm 2011 too slow when performing searches on the application
-
Monday, February 11, 2013 9:24 AM
Hi
i have a current deployment of dynamics crm 2011 and i performing searches on the CRM Application is very slow. The Accounts entity contains about 4million records. can this amount of records cause the CRM to preform searches slowly?secondly how can i Optimize searches on the application? is it a database level issue
please assistance urgently needed
System integrator
- Changed Type JLattimerMicrosoft Community Contributor, Moderator Monday, February 11, 2013 12:42 PM
All Replies
-
Monday, February 11, 2013 9:47 AMAnswerer
Hi there,
Please have a look at this article:
http://quantusdynamics.blogspot.co.uk/2012/11/dynamics-crm-database-optimization-with.html
Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com
- Proposed As Answer by Neil BensonMVP, Moderator Friday, February 15, 2013 12:01 AM
-
Friday, February 15, 2013 3:09 AMModeratorYou would optimize search performance by optimizing the database. Probably your query contains unindexed columns. Add indexes strategically by analyzing with tools such as SQL profiler and db tuning wizard.