Microsoft Dynamics CRM

Forums

Home » Microsoft Dynamics CRM » Microsoft Dynamics CRM Forum
Related Search Results

Query execution time of xx.xx seconds exceeded the threshold of xx seconds

by
on 27 Dec 2012
  • Not Answered

Issue with plug-in in CRM 2011

by
on 28 Feb 2012
  • 0 comments

Avoid Performance Issues by Rescheduling CRM 2011 Maintenance Jobs

by
on 26 Apr 2012
  • 0 comments
Helpful Resources

Dynamics CRM Support Blog

Problems configuring the CRM Outlook client? Use the wizard!

 CRM Resource Center

FAQ About Technical Support
Online | On-Premise

FAQ About Billing

Implementation Guide

Microsoft Dynamics CRM Developer Center and SDK

Query execution time of 10.6 seconds exceeded the threshold of 10 seconds.

This question has suggested answer(s)
Damir Miljic
Posted by
on 5 Oct 2011 5:37 AM

Hi

I'm getting warning in event id 17972 very often:

Query execution time of 10.6 seconds exceeded the threshold of 10 seconds. Thread: 84; Database: Database_MSCRM; Query: sp_getapplock.

Sometimes it is sp_getapplock and other times it can be some SQL query from the CRM system.

Do anyone know of this 10 second threshold? Where are properties for this if I want to increase it?

 

Kind Regards

D
All Replies
  • Incubeus
    Posted by
    on 1 Nov 2011 2:32 PM

    Hi Damir,

    Have you had any luck finding a solution? This issue is bothersome. It fills my eventlogs everyday.

    I tried adjusting the web.config but it still persists.  Any input you have would be great. I will share what I find as well.

    If you don't mind me asking what Rollup are you using for your CRM 2011?  We are currently on RU2 wondering if RU3 will help any. (going to be finding out soon if this persists)

    Thank you
  • Alex Fagundes - PowerObjects
    Posted by
    on 1 Nov 2011 2:42 PM
    Suggested Answer

    Hi,

    This is just a warning and to allow you to fine tune your crm system.  With this information if you see the same query over and over again you can create indexes and will greatly improve performance.  I have seen queries taking 30 s going to 1 s with the addition of a few indexes.

    Alex Fagundes - www.PowerObjects.com
    Global Search for CRM 2011 - Click Here
  • Incubeus
    Posted by
    on 2 Nov 2011 9:59 AM

    Thanks Alex for your insight,  

    Although Indexing is an option, the company I am with prefers not to use that method.  Would you know where this 10s setting is embedded?

    I understand that the event is a warning, I could set Eventviewer not to capture it but I prefer to fix the problem rather then hide it I think the annoyance comes from the amount of times I see it in the event logs. Since we implemented CRM 2011 in Sept.  We have had it show up over 90000 times on both event viewer logging and SQL logs.

    Thanks in Advance for your suggestions.
  • Josh Thompson
    Posted by
    on 17 May 2012 1:21 PM
    Suggested Answer

    Thread is old but for anyone else looking for the answer:

    The setting is found in the ServerSettingsProperties table of the MSCRM_CONFIG database.

    update ServerSettingsProperties set IntColumn='15' where ColumnName='LongQueryThresholdInSeconds'

    Note, this doesn't actually impact any performance rather it reduces the number of MSCRMPlatform warnings you will see in the event log. You should try and identify why the queries are taking more than 10 seconds however.