Sign in

Microsoft.com

Microsoft

Remove From My Forums

Microsoft dynamics crm 2011 too slow when performing searches on the application

Question
0

Sign in to vote
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 JLattimerMVP, Moderator Monday, February 11, 2013 12:42 PM
Monday, February 11, 2013 9:24 AM

All replies

0

Sign in to vote
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
Monday, February 11, 2013 9:47 AM

Answerer
0

Sign in to vote

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

Friday, February 15, 2013 3:09 AM

Moderator