Follow sqlserver-dba.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

SQLServer-DBA.com Links

Dba_db2_button

dba-ninja.com

SQL Server DBA Jobs

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

    DBCC UPDATEUSAGE(db_name)
    exec sp_recompile for all objects

    exec sp_refreshview for all views


Stage II


    DBCC DBREINDEX
    exec sp_recompile for all objects
    exec sp_refreshview for all views


Stage III


    Profiler
    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)


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 SQL Server Rapid Tuning


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