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

Troubleshooting and Tuning Methodology

Now that you have some idea of the attitude and skills that are required for troubleshooting and performance tuning, it is time to look at some of the processes and methodologies for these tasks. Both troubleshooting and tuning benefit from using a standard methodology. So, what is a methodology? A methodology is a set of rules, processes, and steps that you follow in order to perform a task in a scientific and repeatable manner.

Developing a Methodology

In this section, you are introduced to performance tuning, optimization, and troubleshooting methodologies. This is the methodology that I have used for several years. You can take this methodology as a guideline and adapt it to your own needs. This methodology ...

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