Date: Fri, 29 Mar 2024 05:01:42 +0000 (UTC) Message-ID: <467481377.69613.1711688502536@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69612_1761492078.1711688502535" ------=_Part_69612_1761492078.1711688502535 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
You can optimize auditing performance and preserve your complian= ce history through IDERA SQL Compliance Manager archives. Archiving al= lows you to off-load collected and processed events from the Repository dat= abases to an archive database. Your audit data remains available for report= ing and viewing without impacting your collection and processing performanc= e. To view or report on archived events, simply attach the archive database= .
If your environment requires more aggressive data managemen= t, consider implementing a maintenance plan for your arc= hive databases to meet your storage and performance needs. Consider using t= ools such as IDERA SQL Safe to qu= ickly and securely back up archive databases so that you maintain optimal p= erformance on the host SQL Server instance. Also consider grooming older ev= ent data. You can groom audited events from selected archive databases usin= g the Management Console.