CRM 4.0 Very slow in quick search on quote RRS feed

  • Question

  • 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



    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

  • 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