We were getting the below warning in one of our PROD environment.
Query execution time of 30.0 seconds exceeded the threshold of 10 seconds. Thread: 28; Database: PROD_MSCRM; Server:PRODDB01; Query: update tablename set col=......
Using below option, we have changed LongQueryThersholdInSeconds column value in ServerSetingProperties table of MSCRM_Config Database.
update MSCRM_CONFIG..ServerSettingsProperties set IntColumn = '30' where ColumnName='LongQueryThresholdInSeconds'
How do i get CRM to recognize it? The error i’m getting still says what the original setting was. Not the increased time i set it to.
Please advise me on this issue.