Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open the file <install-dir>\SQLWA\etc\mq\schedule.xml in a Notepad or any other editor.


     
  2. Look for the line that specifies the purge schedule in a Standard Cron

    Format (Line 19).
    Change the number 1 to your preferred time value. The new value should be

    Formatand edit the time value in a 24-hour format.


    Image RemovedRestart the SWA services (IDERA Collector Services and IDERA Framework GUI service)

      For example, if you want to set your grooming for 2:10 PM, you should change the time value to 14:10, please check the image below.

    Tip
    titleDefault grooming time

    By default, the grooming schedule time is set to 1:10AM every day.

    Image AddedImage Added

  3. Restart the SWA services (IDERA Collector Services and IDERA Framework GUI service).

 

SQL Workload Analysis makes SQL Server performance tuning easy.

...