Chapter 41. A Performance and Tuning Methodology

Yes, you can tune your SQL Server implementation to perform optimally for you. However, random jabs at bleeding arteries may stop immediate bleeding, but the patient will die before too long. Forgive the graphic analogy, but all too often, performance and tuning is crudely attempted with extremely serious oversights and very often extremely poor results. Usually, you can avoid this outcome if you follow basic, orderly steps when tuning your SQL Server platform and understand the ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.