As a CRM administrator, you may come across the following error in your CRM Event Logs: “Query execution time of XX seconds exceeded the threshold of 10 seconds”
This is said to merely be informational. If you’d like to see the setting in your CRM’s SQL database, run the following script against your CRM’s database:
SELECT IntColumn FROM MSCRM_CONFIG..ServerSettingsProperties WHERE ColumnName=’LongQueryThresholdInSeconds’
It should return the value you had seen in the warning. To lengthen the timeout to stop the error, you can run the following script against your database:
UPDATE MSCRM_CONFIG..ServerSettingsProperties SET IntColumn = ’20’ WHERE ColumnName=’LongQueryThresholdInSeconds’
This will double the timeout threshold to 20 seconds.