Grooming is the process of deleting audit snapshots from the IDERA SQL Secure Repository. Grooming allows you to keep only the permissions data you need for future reporting. SQL Secure allows you to schedule snapshot grooming at the enterprise and at the individual SQL Server instance levels. Keep in mind that baseline snapshots and snapshots associated with saved assessments cannot be groomed.
Grooming should be scheduled for off-peak hours so that it does not interfere with your normal business operation. Depending on the amount of data collected, grooming can be a performance intensive operation. |
To keep a snapshot, mark it as a baseline. For more information, see Designate a baseline snapshot. |
You can configure the enterprise level grooming schedule on the Grooming schedule window.
If you do not want to have a grooming schedule, you can disable the option Enable Grooming Schedule.
Additionally, the Grooming Schedule window informs you the SQL Server Agent Status of the SQL Server hosting the Repository Database. SQL Secure uses this agent for data collection and grooming.
In addition to routine snapshot grooming, the grooming process deletes all the snapshots that are associated with any SQL Server instances you have removed from the SQL Secure Console |
Snapshot retention is the number of days SQL Secure will continue to store all your non-baseline audit snapshots in the SQL Secure Repository.
SQL Secure tells you who has access to what on your SQL Server databases. Learn more > > |
IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
---|