Question:

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:
Created: 2005-01-25

Answer:

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.



Links: