For on-demand database tuning of Manager database, do the following:
Select Manager → <Admin Domain Name> → Maintenance → Database Tuning → Tune Now.
Note
For on-demand database tuning of Central Manager, select Manager → Maintenance → Database Tuning → Tune Now.
Select which tables to tune, either All Tables or only the Event Tables.
Note
Selecting All Tables will tune the entire database, that is, all configurations, user activity, alert information and packet logs, whereas selecting Event Tables tunes alert, host and Sensor performance events.
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.
Click Start.