Date: Thu, 28 Mar 2024 14:45:19 +0000 (UTC) Message-ID: <1219070708.67941.1711637119516@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_67940_1456281152.1711637119511" ------=_Part_67940_1456281152.1711637119511 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Grooming Options window allows you to schedule and configure SQL Diag= nostic Manager Repository grooming. Grooming is the process of deleting met= rics 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 co= llection.
You ca= n limit the amount of data stored in the SQL Diagnostic Manager Repository = by lowering the number of days data is stored. This is particularly importa= nt when monitoring a large number= of servers or when storing Query information at a low threshol= d.
To open the Grooming Options window, = select Tools > Grooming Options from the toolbar menu.<= /span>
You ca= n set the time when SQL Diagnostic Manager grooms the Repository and how ma= ny days your metrics, session details and queries, change log data and inac= tive alerts are saved in the Repository. In addition, you can select how of= ten query data is aggregated and how often that data is groomed from the SQ= L Diagnostic Manager Repository.
The cu= rrent grooming status is listed at the bottom of the Grooming Options windo= w.
=
span>