Any way to set the Poll interval/frequency per server?

• 

  jerryhung wrote:

  Feature #1
  Any way to configure the frequency of SQL Response poll, perhaps to each server?
  say for DEV Servers I only want every 10 mins
  for Staging, every 30 mins
  for Production (not in house so moot point), I want every 1 minute
  
  It is funny, I am looking at a developer's long running "trace" in Profiler
  and he is seeing me/SQL Response in his Profiler ALL THE TIME, which I didn't expect it to be every second
  
  This may put more load onto the "monitored SQL Servers" than I originally expected

  
  For V1.0 the polling is fixed - however different things poll at different rates. For example the performance counters are every 5 seconds - any less and they are just way too inaccurate - and to pick up a long running query of, say, 10 seconds, well we need to poll at least as often as that.
  
  However whilst we run the queries often they are lightweight and should not be contributing any significant overhead
  

  jerryhung wrote:

  Feature #2
  Is there a REFRESH ALL button that go fetches & updates the real-time stats
  Say I saw a Recommendation, went to the server and did it, I want to refresh right away to see if it's gone

  
  This was one of the features that was on the list but didn't make the cut for 1.0 I'm afraid. Hopefully it will be put in for the next feature release.

  Nigel Morse September 12, 2008 05:26

  - 0 +
• 

  jerryhung wrote:

  
  Feature #2
  Is there a REFRESH ALL button that go fetches & updates the real-time stats
  Say I saw a Recommendation, went to the server and did it, I want to refresh right away to see if it's gone

  
  Hi,
  
  SQL Monitor 2.0 has concept of active alerts. This updates iteslf when the condition no longer exists. This should resolve this issue.
  
  Thanks,
  Priya

  priyasinha November 15, 2010 10:54

  - 0 +

Add comment

Please sign in to leave a comment.