Show 3 – Performance Tuning

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