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