Export (0) Print
Expand All

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft