Tuning Methodology

This section describes a tuning methodology that should help you detect performance bottlenecks in your system. I will briefly discuss general performance bottlenecks, but keep in mind that the focus of this chapter—and this book—is query tuning.

So, when your system suffers from performance problems, how do you start to solve the problems?

The answer to this question reminds me of a programmer and an IT manager at a company I worked for years ago. The programmer had to finish writing a component and deploy it, but his code had a bug he couldn’t find. He produced a printout of the code (which was pretty thick) and went to the IT manager, who was in a meeting. The IT manager was extremely good at detecting bugs, which is why the ...

Get Inside Microsoft® SQL Server® 2008: T-SQL Querying now with O’Reilly online learning.

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