Red Gate forums :: View topic - How to turn off deadlock detecting permantely
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

How to turn off deadlock detecting permantely

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Markus



Joined: 26 Apr 2013
Posts: 6
Location: Ohio

PostPosted: Fri Apr 26, 2013 5:34 pm    Post subject: How to turn off deadlock detecting permantely Reply with quote

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.
Back to top
View user's profile Send private message
Admin
Site Admin


Joined: 15 Aug 2004
Posts: 9

PostPosted: Mon Apr 29, 2013 4:21 pm    Post subject: Reply with quote

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_Monitor/ConfigEditor/ConfigurationFileEditor.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).
Back to top
View user's profile Send private message Send e-mail
Markus



Joined: 26 Apr 2013
Posts: 6
Location: Ohio

PostPosted: Tue Apr 30, 2013 7:02 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6668

PostPosted: Thu May 02, 2013 10:16 am    Post subject: Reply with quote

Yes - operating systems previous to Vista leave the config file in the program files folder and Vista and newer redirect to programdata.
Back to top
View user's profile Send private message
bwongz



Joined: 14 Jan 2014
Posts: 1

PostPosted: Tue Jan 14, 2014 5:09 am    Post subject: Cannot Download SQL Monitor Configuration Editor Reply with quote

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 ?
Back to top
View user's profile Send private message
Adam



Joined: 27 May 2008
Posts: 24
Location: Cambridge, England

PostPosted: Mon Jan 27, 2014 9:59 am    Post subject: Reply with quote

A new version is available at: SQL Monitor Configuration File Editor
Back to top
View user's profile Send private message
mvbitt



Joined: 14 Jul 2014
Posts: 1
Location: Brazil

PostPosted: Mon Jul 14, 2014 2:05 pm    Post subject: Link broken Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group