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.
In SQL Workload Analysis you can set your grooming schedule by following these steps:
Look for the line that specifies the purge schedule in a Standard Cron Formatand edit the time value in a 24-hour format. 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.
By default, the grooming schedule time is set to 1:10AM every day. |
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
---|