Podcast Episode 73: SQL Server Performance Tuning
At some point all data administrators will have to tune their environments and there are may ways you might go about that. In this episode, we talk with Pinal Dave about how he does performance tuning and the thought process behind the approach. What I found interesting about this discussion is we have our own version of the how to do things, but there are some basics that everyone should have covered.
This discussion does not get heavy into the how to for all scenarios; however, I think you will find the discussion very informative.