How can I optimize my Microsoft SQL Server (MSSQL) database? I am expecting to log several million events and what to make sure that the database runs at full performance.

Article ID: 35
Category: Web Reports
Applies to:
Updated: 2019-07-31

You can optimize the performance of your database by setting the initial database size to a large number, for example 2Gb.

Please see the additional link for detailed instructions.