Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.

Community Additions

ADD
Show:
© 2015 Microsoft