THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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: http://msdn.microsoft.com/en-us/library/cc966413.aspx (link is at the bottom).

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

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: http://msdn.microsoft.com/en-us/library/dd672789.aspx

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

Leave a Comment

(required) 
(required) 
Submit

About BuckWoody

http://buckwoody.com/BResume.html

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement