How to throttle Redgate monitor for SQL Server to collect all metrics in intervals of say 60 secs

• 
  Hi @Mpaul
  
  It is possible to lower the sampling rate of the Base Monitor across all sampler collections.
  

  
  

  You can change the frequency using the ConfigurationFileEditor utility as described below.
  

  1. Find the ConfigurationFileEditor.exe tool included under the C:\Program Files\Red Gate\Redgate Monitor\BaseMonitor\Tools directory of a base monitor installation.
  2. Right click and run the tool as an Admin
  3. Click on the Load Configuration File option and then select the "RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config" which should be residing under the C:\ProgramData\Red Gate\Redgate Monitor directory by default
     • It's recommended that you save a copy of the config file elsewhere before editing it further- though it should also save a copy itself.
  4. Once you've loaded the config file choose the "select override" option at the top right and choose either the "1/2 default" (i.e. 15 seconds becomes 30 seconds sampler period) or "1/4 default" options (i.e. 15 seconds becomes 1 minute sampler period)
     
  5. Then save the configuration file using the disk icon at the top left and then restart the Redgate Monitor Base Monitor Windows service.

  Please do not change individual sampler frequencies as some samplers rely on others running at the same time and it can cause other issues if they are mismatched.

  Hope this is of assistance, please let us know if not or if you have a specific scenario you're trying to address that requires more input from our side.

  Tom_C February 14, 2025 09:29

  - 0 +

Add comment

Please sign in to leave a comment.