Performance Tuning - Save hundreds of hours

06 May,2013 by Jack Vamvas

Save hundreds of hours of SQL Query Tuning time by following this general approach to query tuning and query optimization efforts.

 Query performance  tuning is a complex area and can be made more difficult if changes are implemented in the incorrect order. ALWAYS do it in this order – as changing system level configurations can undo SQL Statement Tuning . For example, if you make a RAID level change – this may impact query run times.

This general approach is a guide – but is not always practical in an emergency situation , where a pragmatic approach is required to solve the immediate issue

1) Server level tuning

SQL Server - Disk IO performance and SQLIO - SQL Server DBA

2) SQL Server Instance Tuning

Affinity Mask on SQL Server 2008 R2 - SQL Server DBA

3) SQL Server Object Tuning

Concurrency Control – Optimistic and Pessimistic - SQL Server DBA

4) Query Tuning

How to troubleshoot a slow running query - SQL Server DBA

 

Read More

Storage Checklist FAQ - SQL Server DBA

SQL Server Performance Checklist - SQL Server DBA

TempDB performance and strategy checklist - SQL Server DBA


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Performance Tuning - Save hundreds of hours


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer