Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Defining a process for troubleshooting performance issues Expand / Collapse
Author
Message
Posted Monday, August 12, 2013 9:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 3, Visits: 56
Hello there!

The issue of poor database performance is one which presents itself from time to time and there are many techniques which can be employed to examine the root cause of slowness.

Does anyone have a clearly defined process which they use to troubleshoot performance, like a tried and tested 'works for me' method for investigating issues?

For me I might employ the following (not necessarily in this order)

-check if data index/statistics maintenance ran successfully (if possible/appropriate re-run if failed)
-examine fragmentation of indexes (rebuild/re-organ depending on frag amount)
-examine the last time statistics were updated (maybe update stats depending on age and whether a -large number of data changes had taken place)
-check if there's any blocking (kill off the offending process if appropriate)

What would others add/delete from the above list?

A repeatable process for troubleshooting for all performance issues might be difficult to gather but it were possible it would certainly be useful starting point :)
Post #1483380
Posted Monday, August 12, 2013 10:04 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:23 PM
Points: 3,354, Visits: 7,250
You could take a look at this book. It's a complete process for troubleshooting SQL Server
http://www.sqlservercentral.com/articles/books/76296/



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1483382
Posted Monday, August 12, 2013 10:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 3, Visits: 56
Thanks - i'll give it a go
Post #1483387
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse