Nishant Rana's Weblog

Home | Pages | Archives

Query execution time of 60 seconds exceeded the threshold of 10 seconds warning in CRM 2013.

April 10, 2015 12:26 PM


Query execution time of 60 seconds exceeded the threshold of 10 seconds warning in CRM 2013.

We were getting the below warning in one of our test environment

On analyzing figured out that one of the plugin was using retrieve with ColumnSet(true) option i.e. retrieving all the columns of the entity which was not required in this case.

Fetching only the required columns fixed the warning.

The other option could have been indexing or increate the value for LongQueryThersholdInSeconds column in ServerSetingProperties table of MSCRM_Config.

Helpful posts

http://blog.edgewater.com/2013/01/07/microsoft-dynamics-crm-querying-data-using-late-binding-versus-early-binding/

http://www.dynamicscrmpros.com/mscrmplatform-warning-in-event-viewer-in-microsoft-dynamics-cr-event-id-17972/

Hope it helps..

 

Discover more from Nishant Rana's Weblog

Subscribe to get the latest posts sent to your email.

Share It -

Posted by Nishant Rana

Categories: CRM, CRM 2011, CRM 2013, CRM 2015

Tags: , , , ,

3 Responses to “Query execution time of 60 seconds exceeded the threshold of 10 seconds warning in CRM 2013.”

  1. […] Query execution time of 60 seconds exceeded the threshold of 10 seconds warning in CRM 2013.. […]

    Like

    By Query execution time of 60 seconds exceeded the threshold of 10 seconds warning in CRM 2013. | Sreeni Pavalla on April 10, 2015 at 12:46 PM

  2. This approach we used in SanDisk, was really helpful -indexing. But really nice to see it documented here.

    Like

    By deepeshsomani2013 on April 10, 2015 at 2:41 PM

  3. Did this happen after SP1 update? We are having this issue SP-1 was installed.

    Thanks
    Sumukh

    Like

    By Sumukh on June 30, 2015 at 9:54 AM

Leave a Reply

Mobile Site | Full Site

Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.