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

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with O’Reilly online learning.

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