O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Chapter 29. Database System Tuning

As we saw in Chapter 3, one of the responsibilities of the DBA is to tune the system monitor and performance tune the SQL Server solution. When deciding on a tuning methodology there are basically two approaches you can take:

  • Proactive approach. You monitor your SQL Server solution and tune the database system when you notice capacity reaching resource limits.

  • Reactive approach. You wait until events occur, such as users complaining about slow queries or batch processes failing and then tune the database system as required.

Realistically, a combination of both approaches is required because ...

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