Page History
Grooming is the process of deleting metrics stored in the repository that are older than a given date and time, this . This process is important because it optimizes the performance of processes such as data collection.
Note |
---|
When running an upgrade from SQLWA 1.6.3 version and above, the installer runs a clean-up routine before restarting the services. |
In SQL Workload Analysis you can set your grooming schedule by following these steps:
- Open the file <install-dir>\SQLWA schedule file in a text editor such as Notepad, this file is located in the following path: C:\Program Files\Idera\IDERA SQL Workload Analysis\etc\mq\schedule.xml in a Notepad or any other editor.
Search
Lookfor the line that specifies the purge schedule in a
Standard Cron Format (Line 19).
- 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, this should be in a 24-hour format.
- Restart the SWA services (IDERA Collector Services and IDERA Framework GUI service)
standard cron format and edit the time value in a 24-hour format. For example, if you want to set your grooming for 8:00 PM of the 14th day of the month, the cron should be set at: 0 20 14 * * in a standard cron format. Check the images below.
Tip title Default grooming time By default, the grooming schedule time is set
...
SQL Workload Analysis makes SQL Server performance tuning easy.
at 10:00 AM on the 1st day of the month.
- Restart the SQL Workload Analysis services (IDERA Collector Service and IDERA Framework service).
...