THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Buck Woody

Carpe Datum!

Performance Tuning Methodology Preferences

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: (link is at the bottom).

Published Wednesday, January 20, 2010 5:22 AM by BuckWoody



WIDBA said:

The link I get is to the 3.5 year old Waits and Queues document.  A good read, but I would not classify that as a "new" whitepaper.  

January 20, 2010 9:13 AM

Adam Machanic said:

I wonder if Buck meant to link here:

Buck: I hope you're also educating your customers on the "hire Adam Machanic to come in and tune your system" methodology :-)

January 20, 2010 10:06 AM
New Comments to this post are disabled

About BuckWoody

This Blog


Privacy Statement