Chapter 7. Configuring and Tuning SQL Server
by Mark Spenik
IN THIS CHAPTER
Configuring SQL Server
SQL Server 2000 Self-Tuning Features
Configuration Parameters
Advanced Configuration Parameters
Configuration FAQ
You now have SQL Server installed and running. Maybe you are about to roll out your first production database and your boss is breathing down your neck asking, “Mister (or Madam) DBA, have you tuned and optimized the server?” You tell your boss no, but tuning and optimizing SQL Server was next on your list. You bring up the SQL Enterprise Manager. You stare at the Enterprise Manager configuration screen and ask yourself, “So, which knobs do I turn?” How about very few (maybe none), which in many organizations will be the case! Remember the ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
