Show 3 – Performance Tuning

Download Episode (mp3)
You know you have a performance problem in your server, but where do you start looking in order to find what that problem is?
On our 3rd show, we take a deep dive into performance tuning and talk about:

The Top-Down and Bottom-Up methods and when to use which
The various tools SQL Server gives us for performance tuning
How to pinpoint the problem in any of the methods
What to look for when tuning a slow running query or process
What to look for when analyzing execution plans
Why you should always blame the network :)
And more..

What's your method for performance tuning? What are the tools that you use? Tell us in the comments..