Export (0) Print
Expand All
1 out of 13 rated this helpful - Rate this topic

Optimizing Server Performance

SQL Server 2000

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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.