How to turn off deadlock detecting permantely

Monitor, diagnose and receive alerts to problems across your SQL Servers.

How to turn off deadlock detecting permantely

Postby Markus » Fri Apr 26, 2013 4:34 pm

I am new to SQL Monitor as of this week. We have one SQL Server that has a ton of deadlocks and is filling up the SQL Server log. I run the command to turn off deadlock detection (DBCC TRACEOff (1204, -1) but SQL Monitor turns it right back on. Also, I have the alert turned off in SQL Monitor for Deadlock and Deadlock trace flag disabled.
Posts: 6
Joined: Fri Apr 26, 2013 4:31 pm
Location: Ohio

Postby Admin » Mon Apr 29, 2013 3:21 pm


SQL Monitor does not disable the 1204 trace flag if you suppress the alerts for deadlocks, but you can disable the trace flag by reconfiguring SQL Monitor:
  • First, locate the configuration file on the machine where the SQL Monitor Base Monitor service is hosted.
    Location: C:\\ProgramData\\Red Gate\\SQL Monitor 3
    File Name: RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config
  • Make a copy of this file and name it something useful like RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config_old
    This will act as a backup of the configuration file so that your changes can be reversed.
  • Download and run the SQL Monitor Configuration Editor ...
  • You will be prompted to "Load a configuration file". Find the .config detailed in step 1.
  • You will be presented with a list of all the configuration options available. These relate to each item in the polling schedule. Any check box which is un-checked automatically uses the default. Simply locate in the list "[Cluster].[SqlServer].[DeadlockTraceFlag]" and select "Disabled" from the drop down menu which appears.
  • Once complete, click "Save Changes" and restart the SQL Monitor Base Monitor service. If you have any unexpected results then please delete your edited configuration file and rename the copy (then also restart the service).
Site Admin
Posts: 9
Joined: Sun Aug 15, 2004 9:44 am

Postby Markus » Tue Apr 30, 2013 6:02 pm

I don't see a path like described. However I see this path:

C:\\Program Files\\Red Gate\\SQL Monitor 3\\BaseMonitor

but the file is called this : Response.Engine.Alerting.Base.Service.exe.config

is this the right file?
Posts: 6
Joined: Fri Apr 26, 2013 4:31 pm
Location: Ohio

Postby Brian Donahue » Thu May 02, 2013 9:16 am

Yes - operating systems previous to Vista leave the config file in the program files folder and Vista and newer redirect to programdata.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Cannot Download SQL Monitor Configuration Editor

Postby bwongz » Tue Jan 14, 2014 4:09 am


I am trying to resolve this issue we have here but I am unable to download the SQL Monitor Configuration Editor.
The link does not seem to work.

Can you tell me where I can get the install file ?
Posts: 1
Joined: Tue Jan 14, 2014 4:05 am

Postby Adam » Mon Jan 27, 2014 8:59 am

A new version is available at: SQL Monitor Configuration File Editor
Posts: 24
Joined: Tue May 27, 2008 12:40 pm
Location: Cambridge, England

Link broken

Postby mvbitt » Mon Jul 14, 2014 1:05 pm

my browser was trouble with '%20' in link.
now i solve and downloaded file.
it works, thanks.


I'm trying download the SQL Monitor Configuration Editor but i the link is broken.
Can you send the new link?
Posts: 1
Joined: Mon Jul 14, 2014 1:02 pm
Location: Brazil

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests