Chapter 7. Tuning SQL Server Configuration
Unlike other major RDBMS products on the market such as Oracle 9i and 10g, which have hundreds of parameters to tweak, SQL Server, for the most part, is self-configuring. That means that the default setting will work best for most scenarios.
Having said that, there are some configuration settings you can tweak, after careful analysis of the application, performance counters, SQL traces/profiling, and DMVs data, that warrant such action. If you need help with performance monitoring, SQL Server trace and profiling, and DMVs, please refer to the relevant chapters in this book for detailed discussion on those subjects.
In this chapter, we will discuss ways on how to tweak some advanced SQL Server settings to maximize performance. We will start from where and how to find existing SQL Server configuration settings. Next we will examine some important server settings, what they mean, and implications of changing them to different values.
As mentioned earlier, SQL Server is self-tuning for the most part. Only change server configuration settings when you have solid evidence that it really helps performance.
Get Professional SQL Server® 2005 Performance Tuning 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.
