Page History
...
Tip |
---|
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 Open the Grooming Options window , select Tools by selecting > 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 a 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 updated information on 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.
Scroll pdf ignore | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
Newtabfooter |
| ||||||||||||||||||||||||||||||||||||||||||||||||||
Newtabfooter | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal