Page History

...

To open the Grooming Options window, select Tools > Grooming Options from the toolbar menu.

Available Grooming options

You can set the time when SQL Diagnostic Manager grooms the Repository and how many days your metrics, session details and queries, change log data, and inactive alerts are saved in the Repository. In addition, you can select how often query data is aggregated and how often that data is groomed from the SQL Diagnostic Manager Repository.

...

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
  

Image Added

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.