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
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
Profiler
Query Hints
Hint: Advise them of the need to write scalable code to start with !
SQL Server Performance Checklist
SQL Server Performance ,memory pressure and memory usage
Author: Tom Collins (http://www.sqlserver-dba.com)
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |