Call now: (800) 766-1884  



 Home


 SQL Server Tips
 SQL Server Training

 SQL Server Consulting
 SQL Server Support
 SQL Server Remote DBA



 Articles
 Services
 SQL Server Scripts
 Scripts Menu



 

 

 

   
  SQL Server Tips by Robin Schumacher

The Simplified Performance Tuning Model

When approaching tuning in SQL Server, the DBA will work through the following three areas:

  • Configuration

  • SQL Optimization

  • Physical Design Revisions

Thatís it. There can be a lot of complexity and effort involved in working through these steps, but broadly speaking, these are the categories the DBA will be engaged in.

The first thing to understand is these three areas are presented in reverse order of their usual performance impact. This means making configuration changes will buy the least amount of performance optimization. Making SQL optimization changes will buy more performance optimization, and making physical design revisions has the largest potential for performance increase.

These steps are presented according to ease of application. It is not usually a problem to make SQL Server parameterization or server configuration tweaks. SQL optimization is less dangerous and less complex than making physical design revisions.

The remaining sections of this chapter will work through each step and correlate diagnostics presented in earlier chapters with recommendations for performance improvement. The meaning of the various diagnostics along with how to obtain them will not be covered again. Therefore, if a particular statistic is needed, the index of this book should be utilized to locate the correct chapter in which the particular metric is covered in detail.


The above book excerpt is from:

High-Performance SQL Server DBA
Tuning & Optimization Secrets

ISBN: 0-9761573-6-5
Robin Schumacher

 http://www.rampant-books.com/book_2005_2_sql_server_dba.htm  

 

Burleson Consulting Remote DB Administration


 

 


 

 

 

 

 
Burleson is the America's Team

Note: The pages on this site were created as a support and training reference for use by our staff of DBA consultants.  If you find it confusing, please exit this page.

Errata?  SQL Server technology is changing and we strive to update our SQL Server support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:and include the URL for the page.
 


Burleson Consulting
SQL Server database support

 

Copyright © 1996 -  2013 by Vaaltech Web Services. All rights reserved.

Hit Counter