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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.