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

(0) Share

Report

Posted on by Damir Miljic

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

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Incubeus 40 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

alf 17,915 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Incubeus 40 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Josh Thompson 1,115 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No