Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Query execution time of 10.6 seconds exceeded the threshold of 10 seconds.

    Although the thread has its time the problem is always recurrent, I totally agree with Alex Fagundes, if anyone really wants to "fix the problem", the best way would be to analyze the queries and try an indexing solution to optimize the performance.

  • Suggested answer
    Josh Thompson Profile Picture
    Josh Thompson 1,115 on at
    Re: Query execution time of 10.6 seconds exceeded the threshold of 10 seconds.

    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.

  • Incubeus Profile Picture
    Incubeus 40 on at
    Re: Query execution time of 10.6 seconds exceeded the threshold of 10 seconds.

    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.

  • Suggested answer
    alf Profile Picture
    alf 17,915 on at
    Re: Query execution time of 10.6 seconds exceeded the threshold of 10 seconds.

    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.

  • Incubeus Profile Picture
    Incubeus 40 on at
    Re: Query execution time of 10.6 seconds exceeded the threshold of 10 seconds.

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans