Monitoring interval

Comments

• Matthew Flatt Redgate › Posts: 255 Bronze 5

  January 19, 2009 8:48AM

  Hi,
  
  Currently there isn't an option to adjust the polling time of SQL Response.
  
  This will be considered for a future release, thank you for your feedback.

  Matthew Flatt
  Redgate Foundry

  0 · Share on Twitter
• JohnWCrosby Posts: 3

  February 28, 2011 2:10PM

  I was reading this post from 2 years ago, was the ability to change the interval ever introduced? Additionally, what is the current interval?

  0 · Share on Twitter
• priyasinha Redgate › Posts: 548 Silver 1

  March 1, 2011 5:11AM

  Hi,
  
  You can change it via config file but it is not exposed in UI. You can navigate to the folder where you have installed "Alert Repository", there is a file called Config.xml here. This lists all the polling frequency.
  
  Please always take a backup of this file before making any changes. Also, you would need to restart the service after you have edited config.xml.
  
  Thanks,
  Priya

  Priya Sinha
  Project Manager
  Red Gate Software

  0 · Share on Twitter
• JohnWCrosby Posts: 3

  March 1, 2011 8:02AM

  I can not locate a config.xml file on the machine where SQL Monitor is installed - by the way I'm using SQL Monitor which I thought was simply the replacement product for SQL Response - how can I adjust the intervals for SQL Monitor?

  0 · Share on Twitter
• priyasinha Redgate › Posts: 548 Silver 1

  March 1, 2011 10:53AM

  Hi John,
  
  We have a dedicated forum for SQL Monitor. You might want to post your queries here http://www.red-gate.com/messageboard/viewforum.php?f=133 instead.
  
  Regarding monitoring frequency, though you can change via this config file RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config which is located in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Monitor 2 (or equivalent location) ... I wouldn't recommed it. These schedule have been set up with optimum results in mind for things like performance, data availability etc. Changing the schedule can affect alerts adversely.
  
  Also, would be good to know though that why do you want to change it? Is there any specific problem you are facing?
  
  Thanks,
  Priya

  Priya Sinha
  Project Manager
  Red Gate Software

  0 · Share on Twitter
• JohnWCrosby Posts: 3

  March 2, 2011 11:35AM

  I'm actually more interested in simply knowing what the intervals are at this point. We are looking to use the information gathered for performance benchmarking, so one major question is, how often is the data gathered? Every 15 minutes is useless for example because it's too large of a gap.

  0 · Share on Twitter
• priyasinha Redgate › Posts: 548 Silver 1

  March 3, 2011 12:06PM

  Hi John,
  
  Different data collection has different frequency. It can vary anything from 10 seconds (for pings) to ones a week (for index collection). If you want to know rate of any particular data collection then please ask. I can send you the detail.
  
  Thanks,
  Priya

  Priya Sinha
  Project Manager
  Red Gate Software

  0 · Share on Twitter
• priyasinha Redgate › Posts: 548 Silver 1

  March 4, 2011 5:54AM

  Hi John,
  
  I have just sent you an email with polling frequency for all the data collection. Please let us know if you dont receive it.
  
  Thanks,
  Priya

  Priya Sinha
  Project Manager
  Red Gate Software

  0 · Share on Twitter
• Michal_148 Posts: 3 New member

  July 2, 2018 1:11PM edited July 2, 2018 1:13PM

  error
  

  0 · Share on Twitter