Chapter 40. Configuring, Tuning, and Optimizing SQL Server Options
by Paul Bertucci
IN THIS CHAPTER
SQL Server Instance Architecture
Configuration Options
Fixing an Incorrect Option Setting
Setting Configuration Options with SQL Enterprise Manager
Obsolete Configuration Options
Configuration Options and Performance
As was already discussed in Chapter 37, “Monitoring SQL Server Performance,” many components of a system can be monitored and tuned to yield high performance. These addressable components can be server hardware, network configuration, memory allocation, disk systems usage, database design techniques, and so on. This chapter will delve a bit more into what can be done in the SQL Server configurable options—particularly, what can be improved ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.