Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 4.0 Very slow in quick search on quote RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    We are experiencing issues with Quick find Searches in CRM 4.0 environment. Particularly with Quote record. The outlook client gets freezed for few minutes when a search is hit. and sometimes error is thrown when a wild card search is performed.

    Currently 5 fields are enabled for find columns, in that 3 are custom fields. and 14 fields are available in the view columns. We are rebuilding Index every week. but i'm not sure if a proper index is available for the search fields.

    Any suggesstion is welcomed

    Regards,

    Hari.

    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Tuesday, December 3, 2013 6:03 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    One possible reason for a very slow repsonse is if SQL does not have any statistics on one of the find columns. If this is the case, the query optimiser may decide to create the statistics, and if the data quantity is large, this may time out. You can stop the auto-creation of statistics by setting the database option 'Auto Create Statistics' to false.

    Another possible cuase of performance problems is if the tempdb database has little free space.

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Tuesday, December 3, 2013 4:52 PM
    Moderator