Professional SQL Server® 2005 Performance Tuning

1.4. Summary

Performance tuning isn't an art, it's a science. In this chapter you learned about the science of performance tuning. You started with the steps in the methodical approach to performance tuning: starting from the problem statement, moving onto the plan of attack, data collection, followed by data analysis, and then repeating until you achieve your goal. You were introduced to some of the many tools available to assist with performance tuning. Some of these are covered in more detail throughout the remainder of this book. In the next chapter you will learn about using Performance Monitor to look at server resources.