O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required