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.
Look Search for the line that specifies the purge schedule in a Standard Cron Format standard cron format and edit the time value in a 24-hour format. For For example, if you want to set your grooming for 28:10 PM, you should change the time value to 14:10, please check the image 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 1:10AM every dayat 10:00 AM on the 1st day of the month.
- Restart the SWA SQL Workload Analysis services (IDERA Collector Services Service and IDERA Framework GUI service).
SQL Workload Analysis makes SQL Server performance tuning easy.
...