Optimizing Server Performance

Microsoft® SQL Server™ 2000 automatically tunes many of the server configuration options, therefore requiring little, if any, tuning by a system administrator. Although these configuration options can be modified by the system administrator, it is generally recommended that these options be left at their default values, allowing SQL Server to automatically tune itself based on run-time conditions.

However, if necessary, the following components can be configured to optimize server performance:

• SQL Server Memory
  
  
• I/O subsystem
  
  
• Microsoft Windows NT® options