How to turn off deadlock detecting permantely

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

How to turn off deadlock detecting permantely

Postby Markus » Fri Apr 26, 2013 5: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.
Markus
 
Posts: 6
Joined: Fri Apr 26, 2013 5:31 pm
Location: Ohio

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

Hello,

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
    ftp://support.red-gate.com/patches/SQL_ ... Editor.zip
  • 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).
Admin
Site Admin
 
Posts: 9
Joined: Sun Aug 15, 2004 10:44 am

Postby Markus » Tue Apr 30, 2013 7: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?
Markus
 
Posts: 6
Joined: Fri Apr 26, 2013 5:31 pm
Location: Ohio

Postby Brian Donahue » Thu May 02, 2013 10: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: 6668
Joined: Mon Aug 23, 2004 10:48 am

Cannot Download SQL Monitor Configuration Editor

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

Hi

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 ?
bwongz
 
Posts: 1
Joined: Tue Jan 14, 2014 5:05 am

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

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

Link broken

Postby mvbitt » Mon Jul 14, 2014 2: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?
mvbitt
 
Posts: 1
Joined: Mon Jul 14, 2014 2:02 pm
Location: Brazil


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests