Grooming is the process of deleting metrics stored in the repository that are older than a given date and time. 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 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
![](/download/attachments/12312708130/mq%20schedule%20swa.png?version=1&modificationDate=1475154647533&api=v2)
Search for the line that specifies the purge schedule in a standard cron format and edit the time value in a 24-hour format. For example, if you want to set your grooming for 28:20 PM, change the time value to 14:20 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 to 1at 10:10 00 AM every dayon the 1st day of the month. |
![](/download/attachments/12312708130/mq%20schedule%20swa1.png?version=2&modificationDate=1475575627573&api=v2)
- Restart the SQL Workload Analysis services (IDERA Collector Service and IDERA Framework service).
...