The Grooming Options window allows you to schedule and configure SQL Diagnostic Manager Repository grooming. Grooming is the process of deleting metrics stored in the SQL Diagnostic Manager Repository that are older than a given date and time. It is important to groom data from your Repository to optimize the performance of processes such as report generation and data collection.
You can limit the amount of data stored in the SQL Diagnostic Manager Repository by lowering the number of days data is stored. This is particularly important when monitoring a large number of servers or when storing Query information at a low threshold.
Access the Grooming Options window
To open the Grooming Options window, select Tools > Grooming Options from the toolbar menu.
In the Grooming Options window you can set an specific hour or determine after how many hours you want to groom your data and aggregate queries.
Also, you can define when your data should be groomed to save repository space, under the following options (in days):
- Groom standard metrics and baselines older than
- Groom Sessions, Queries, Deadlocks, Waits, and History Browser data older than
- Groom inactive Alerts older than
- Aggregate query data into daily records after
- Groom Change Log data older than
- Groom Prescriptive Analysis data older than
- Aggregate forecasting data to daily records after
- Groom forecasting data older than
The current grooming status is shown at the bottom of the Grooming Options window, it displays the current status of the grooming and the aggregation actions. It also displays the date and time of the latest operation, and the current completion status. Click Refresh to get the updated information of these actions at any time.
Click the options Groom Now and Aggregate Now located at the bottom of the Grooming Options window, to perform these actions instantly.