--- title: "Automate database tuning" slug: "automate-database-tuning-2" tags: ["Product Usage", "IPS 11.1.x"] updated: 2026-11-19T12:30:20Z published: 2026-11-19T12:30:20Z canonical: "docs.trellix.com/automate-database-tuning-2" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Automate database tuning 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:** 1. Go to **Manager** → **** → **Maintenance** → **Database Tuning** → **Automated Tuning**. > [!NOTE] > Note > > To schedule database tuning in Central Manager, select **Manager** → **Maintenance** → **Database Tuning** → **Automated Tuning**. **Database Tuning Scheduler**![Database Tuning Scheduler](https://cdn.us.document360.io/0d453a50-e1da-4d4a-9409-fea7959614d8/Images/Documentation/uuid-0c0d92a3-436a-65d1-685f-685c655c6669(7).jpg?sv=2026-02-06&spr=https&st=2026-11-20T09%3A24%3A16Z&se=2026-11-20T10%3A24%3A16Z&sr=c&sp=r&sig=niVBTm2EXPYYsI8LZZ8PNLakDTFF1mqrLmAxMotmSd0%3D) 2. Select **Yes** at **Enable Scheduled Tuning?** 3. Select the day of the week when database tuning will occur (**Recur every**). 4. Use the **Hr** and **Min** drop-down menus to select the process start time. 5. 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. 6. Click **Save**. The database tuning process is now enabled to start automatically on the configured day and time. 7. (Optional) Click ![GUID-DE8F9231-1BB5-42A7-B78B-1FDD431543A8-low.png](https://cdn.us.document360.io/0d453a50-e1da-4d4a-9409-fea7959614d8/Images/Documentation/uuid-dee6af6b-3b7c-566d-9e87-c2e3fc01abd8(9).png?sv=2026-02-06&spr=https&st=2026-11-20T09%3A24%3A16Z&se=2026-11-20T10%3A24%3A16Z&sr=c&sp=r&sig=niVBTm2EXPYYsI8LZZ8PNLakDTFF1mqrLmAxMotmSd0%3D) to clear current changes and view the last saved configuration. 8. (Optional) Go to **Manager** → **** → **Maintenance** → **Scheduler Details** to view the overall scheduled tasks in the Manager. 9. Click **Back** to return to the **Automated Tuning** page. > [!NOTE] > 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](/network-and-platform/docs/using-the-database-admin-tool-2) and [Tune your database using dbadmin.bat](/network-and-platform/docs/tune-your-database-using-dbadmin-bat-2).