I’m holding Performance Tuning Workshops this week for my clients in Washington and Idaho. During that workshop, I explain that there are several ways to examine the SQL Server component of an application. There’s “Hardware Component Pressure Measurement”, “Code Optimization” and “Index Analysis” as starting points, and most folks start there and then move on to use all of them in a mix. But a newer methodology called ‘Wait State Analysis” helps you to evaluate what the system is waiting on, so that you can knock those down one at a time.

 

I mention in the presentations that there is a new whitepaper out on that, and I promised to share that link here. So without further ado, here it is: http://msdn.microsoft.com/en-us/library/cc966413.aspx (link is at the bottom).