Query execution time of xxxx seconds exceeded the threshold of 10 seconds

When tring to delete one of the custom entity I was getting failure in deletion and when looked into the event view I saw the message

Query execution time of 30.0 seconds exceeded the threshold of 10 seconds


After a quick google I found the value of threshold is stored in the ServerSettingProperties table of MSCRM_Config database, I used following queue to update the value

use mscrm_config

update serversettingsproperties
set intcolumn = 25
where columnname = 'longQueryThresholdInSeconds'


http://community.dynamics.com/crm/f/117/t/64580.aspx