Tune your database on-demand

For on-demand database tuning of Manager database, do the following:

1. 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.

2. 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, and alert information, whereas selecting Event Tables tunes alert, host and Sensor performance events.

   Note

   The iv_packetlog table is not tuned in this method. You need to tune the database using dbadmin.bat or dbtuning.bat to tune this table. For more information on tuning the database using dbadmin.bat, refer to Using the database admin tool and Tune your database using dbadmin.bat.

3. Click Start.