Implementation Guide › Planning Your Implementation › SQL Database Settings

SQL Database Settings

To achieve the best performance, tune the following database settings:

Autogrowth

Set the Autogrowth properties for the all databases, as follows:

• File Growth Percent: 50%
• Maximum File Size: Unrestricted File Growth

Note: For more information about setting the Autogrowth properties, see the documentation for the database that you are using.

Tune the autogrowth property on the following databases:

• WPDS (workflow)
• SDB (eurekify_sdb)
• TicketDB (eurekify_ticketdb)
• ReportDB and I2DB (gvm_datawarehouse)

Maximum threads

Set the maximum worker threads to 12 threads per CPU in the MAX_THREADS setting in the GeneralMonitor.properties file.

The GeneralMonitor.properties file is installed in the following location by default:

gm_install\app_server\Workpoint

Note: If you performed a new installation, you do not need to modify these settings.

(Optional) After a large data import or purge, you may experience performance degradation. To improve performance, run the dbutil with the ‘-in’ flag on the SDB database. This rebuilds the indexes in the relevant database.