SQL Server 2000 Self-Tuning Features

One goal of the Microsoft SQL Server team was to create a product that for the majority of installations would be self-tuning and would require very limited changes to configuration parameters to obtain optimum performance. In previous versions of SQL Server, two key DBA tuning areas that were frequently not set correctly and could impact system performance were SQL Server memory allocation and read aheads. With SQL Server 7.0, both features became dynamic and no longer require DBA intervention. Both of these features are available as well in SQL Server 2000 and are discussed in more detail in the next section. One other key area changed in SQL Server 7.0 and enhanced in SQL Server 2000 is locking; it is discussed ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.