Dynamics CRM Support Blog
Problems configuring the CRM Outlook client? Use the wizard!
CRM Resource Center
FAQ About Technical SupportOnline | On-Premise
FAQ About Billing
Microsoft Dynamics CRM Developer Center and SDK
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?
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)
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.comGlobal Search for CRM 2011 - Click Here
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.
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.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13