SQL Server Rapid Tuning

19 August,2008 by Tom Collins

SQL Server Performance sometimes  get very slow. There can be many reasons for the sudden slow down. A systematic approach - can give you a plan to progress.

I use this approach in general situations , where the user has complained of general SQL performance slowdown  without giving you specific feedback .


After every stage , check performance.  If the performance is still very slow - progress with other analysis. Contact me if you need assistance


Stage I

UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all objects

    exec sp_refreshview for all views

Stage II

    exec sp_recompile for all objects
    exec sp_refreshview for all views

Stage III

    Query Hints



Hint: Advise them of the need to write scalable code to start with !

 Related Posts

SQL Server Performance Killers

SQL Server Performance Checklist

SQL Server Performance ,memory pressure and memory usage

Author: Tom Collins (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

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

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.


Post a comment on SQL Server Rapid Tuning

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