Page History
The Set Maintenance Schedule window allows you to specify when IDERA SQL Compliance Manager should perform maintenance tasks on the Repository, such as rebuilding indexes in the event and archive databases. Because these tasks occasionally are resource-intensive and require extra disk space, consider specifying a time period with slow activity.
During the specified time each day, SQL CM Compliance Manager continues to execute the required maintenance tasks on any event databases or attached archive database that is not yet maintained, until all databases are maintained. These tasks are performed as background processes during the allotted time period.
...
Info |
---|
Specify a duration time that is larger than the Collection Server heartbeat interval. By default, the Collection Server heartbeat is five minutes. |
...
Excerpt |
---|
SQL Compliance Manager audits all activity on your server. Learn more > > |