Monitoring interval

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

Monitoring interval

Postby xdai » Fri Jan 16, 2009 6:03 pm

Hi,
Is there anyway we could modify the monitoring interval time, so to reduce the io to the database server? thanks
xdai
 
Posts: 69
Joined: Wed Dec 31, 2008 11:50 pm

Postby Matthew Flatt » Mon Jan 19, 2009 2:48 pm

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
Test Engineer, HyperBac
Matthew Flatt
 
Posts: 253
Joined: Tue Jan 15, 2008 4:45 pm

Anything new?

Postby JohnWCrosby » Mon Feb 28, 2011 8:10 pm

I was reading this post from 2 years ago, was the ability to change the interval ever introduced? Additionally, what is the current interval?
JohnWCrosby
 
Posts: 3
Joined: Mon Feb 28, 2011 8:08 pm

Postby priyasinha » Tue Mar 01, 2011 11:11 am

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

No Config.xml

Postby JohnWCrosby » Tue Mar 01, 2011 2:02 pm

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?
JohnWCrosby
 
Posts: 3
Joined: Mon Feb 28, 2011 8:08 pm

Postby priyasinha » Tue Mar 01, 2011 4:53 pm

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby JohnWCrosby » Wed Mar 02, 2011 5:35 pm

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.
JohnWCrosby
 
Posts: 3
Joined: Mon Feb 28, 2011 8:08 pm

Postby priyasinha » Thu Mar 03, 2011 6:06 pm

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby priyasinha » Fri Mar 04, 2011 11:54 am

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests