Strategy to Improve SQL Server Performance

Leave a comment (0) Go to comments

What Steps / Strategy we should opt to Improve SQL Server Performance ?

Increasing SQL Server Performance being expected by every DBA. Performance can not be increased just by running perfmon , task manager or running profile. We should have straight forward steps to increase SQL Server Performance.

The Steps to Improve SQL Server Performance

  1. Find the bottlenecks hidden in your system – Know what to measure and how to measure it!
  2. Produce "Top 10/20 Reports" of queries adversely affecting your business – What to fix first
  3. Analyze the causes – Know the important technical details of SQL Server real world operation
  4. Implement solutions – Increase SQL Server performance with improvements that are worth the cost
  5. Do the right thing at first step – Increasing Hardware might not increase your performance, if your design / TSQL is not designed properly.

This is pretty common thing, but I explicitly need to write this, as one of my customer wanted to understand, how we actually increase the SQL Server performance.

EOF - Strategy to Improve SQL Server Performance, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.