Polling frequency for all the data collection

Best Answer

• Alex B Posts: 1,158 Diamond 4

  July 4, 2018 2:02PM Answer ✓

  Hi @Michal_148,
  
  You can see the default polling frequencies by using the included ConfigurationFileEditor.exe located at C:\Program Files\Red Gate\SQL Monitor\BaseMonitor (using default install directory).
  
  To use this utility to see the polling frequencies please follow these steps:
  

  1. First, locate the configuration file on the machine where the SQL Monitor Base Monitor service is hosted. Location: C:\ProgramData\Red Gate\SQL Monitor
     File Name: RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config<br>Note: this is the <b>programDATA</b> folder (hidden folder) not the program files folder where there is a similarly named file.<br><br>
  2. Make a copy of this file and name it something useful like RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config_backup
     This will act as a backup of the configuration file so that your changes can be reversed.
     
     
  3. Run the SQL Monitor Configuration Editor as an administrator (right click > Run As):
     C:\Program Files\Red Gate\SQL Monitor\BaseMonitor\Tools\ConfigurationFileEditor.exe<br><br>
  4. You will be prompted to "Load a configuration file". Find the .config file detailed in step 1.
     
     
  5. 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. To view the value for the collection, tick the box and it will show you the period of the collection. 
     You can then also customize it at this point.  Increasing the frequency will cause more data to be gathered and cause more impact on both the system you are monitoring and the system where the Base Monitor is installed.
     
     
  6. 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).

  Kind regards,
  Alex

  Product Support Engineer | Redgate Software
  
  Have you visited our Help Center?

  0 · Share on Twitter