Saturday, June 11, 2011

Performance Tuning is a Science, NOT an Art

The field of SQL Server performance tuning is vast.  Many books, training classes, blogs, articles,  and careers are made based on this subject.   All too often, I hear that performance tuning is an art and not a science.  This is wrong thinking.  Sometimes I see SQL administrator professionals analyze a server finding no performance issue and yet I find a glaring problem withing minutes of signing onto the server.    There have been many examples of where I analyzed the root cause of a performance issue only to find I was wrong about the root cause.  There has to be a clearly defined method of analyzing performance issues such that SQL administrator professionals can confidently and consistantly determine cause and effect change.

I created a separate blog to look at this issue.

No comments:

Post a Comment