When scheduling database tuning, set a time when no other scheduled functions (archivals, backups, file maintenance) are running. The time should be a minimum of an hour after/before other scheduled actions.
To schedule database tuning, do the following:
Steps:
Go to Manager → <Admin Domain Name> → Maintenance → Database Tuning → Automated Tuning.
Note
To schedule database tuning in Central Manager, select Manager → Maintenance → Database Tuning → Automated Tuning.
Database Tuning Scheduler.jpg "GUID-673493ED-C9C7-434C-B00F-B5A67FEF8C10-low.jpg")
Select Yes at Enable Scheduled Tuning?
Select the day of the week when database tuning will occur (Recur every).
Use the Hr and Min drop-down menus to select the process start time.
Select which tables to tune, either All Tables or only the Event Tables.
Note the Last Tuning time. This indicates the last time the database tuning process occurred.
Click Save.
The database tuning process is now enabled to start automatically on the configured day and time.
(Optional) Click
.png)
to clear current changes and view the last saved configuration.(Optional) Go to Manager → <Admin Domain Name> → Maintenance → Scheduler Details to view the overall scheduled tasks in the Manager.
Click Back to return to the Automated Tuning page.
Note
If you are using any Manager version prior to 11.1 Update 5 release, you need to manually perform the weekly offline database tuning using dbadmin.bat or dbtuning.bat to tune iv_packetlog table. The offline tuning of the database can be performed irrespective of the table size. For more information on tuning the database using dbadmin.bat, refer to Using the database admin tool and Tune your database using dbadmin.bat.