Optimizing Server Performance

Microsoft SQL Server automatically tunes many of the server configuration options, so system administrators are required to do little, if any, tuning. These configuration options can be modified by the system administrator, but we generally recommend that administrators leave the server configuration options at their default values. The default settings allow SQL Server to automatically tune itself based on run-time conditions.

In This Section

Topic

Description

Optimizing Server Performance Using Memory Configuration Options

Contains information about configuring SQL Server memory options.

Optimizing Server Performance Using I/O Configuration Options

Contains information about configuring SQL Server I/O usage options.

Optimizing Server Performance Using Windows Options

Contains information about configuring Microsoft Windows options to optimize SQL Server performance.