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

 

Leave a Reply