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 12345»»»

Troubleshooting Expand / Collapse
Author
Message
Posted Thursday, April 2, 2009 12:02 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 29, 2014 8:26 PM
Points: 89, Visits: 469
Comments posted to this topic are about the item Troubleshooting


__________________________________________________

Mike Walsh
SQL Server DBA
Blog - www.straightpathsql.com/blog |Twitter
Post #688548
Posted Thursday, April 2, 2009 2:52 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:37 AM
Points: 5,353, Visits: 1,389
Good one from a new author. Keep it up.


Post #688630
Posted Thursday, April 2, 2009 6:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:31 PM
Points: 11,265, Visits: 13,027
Nice job Mike. Sometimes we think we are doing things in order, but it really is a shotgun approach. This can help us have a plan.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #688750
Posted Thursday, April 2, 2009 6:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 11:33 AM
Points: 2,670, Visits: 19,244
Great article, this is perhaps the worst offense I see in day to day work, a missing or unclear plan that results in misguided or no actual progress.

Thanks!

Jon


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #688756
Posted Thursday, April 2, 2009 6:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:43 AM
Points: 7,005, Visits: 8,453
Nice approach list

The "Remain Calm / Keep your head cool / Keep on breathing" should actually be put after every major point.
In case of urgency, that is vital !

Last point to add: Lose the stress / have a pint / enter the cool down area


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #688761
Posted Thursday, April 2, 2009 6:49 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 8:05 AM
Points: 50, Visits: 120
Great article, thanks very much!
Post #688802
Posted Thursday, April 2, 2009 7:15 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, August 29, 2014 8:26 PM
Points: 89, Visits: 469
Thanks for the comments thus far :) I have to admit I got scared (but remained calm and handled it in an orderly fahsion ) when I saw all of the comment alerts pop up on the phone's mail client.

To the comments about the importance of remaining calm, a great piece of advice I received and neglected to put into the article fits here. It was a Paramedic class instructor and he said that paramedics need to be like ducks. If you ever watch the duck on the water, they are in control, just sitting there calmly and slowly moving where they need to. Look under the water and they are paddling feverishly. In other words, don't be slow but don't be hustled and rush either. Sometimes when we troubleshoot an issue we need to move quickly but quickly doesn't mean so fast that we lose all control and all appearance of control and start doing stupid things.



__________________________________________________

Mike Walsh
SQL Server DBA
Blog - www.straightpathsql.com/blog |Twitter
Post #688846
Posted Thursday, April 2, 2009 7:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 21, 2010 8:47 AM
Points: 11, Visits: 264
Fantastic article. All too often we find ourselves thrown into panic mode when a major event happens, especially when it's the busiest part of the day. This is usually exacerbated by the CIO spewing "We're losing 10,000 dollars a minute while this is down!" or something similar, trying to shock the DBA into fast action. I wish more tech managers/leaders understood the point Mike is making with this article.

One minor grammatical bug: "You arrive on seen" should read: "You arrive on scene".
Post #688888
Posted Thursday, April 2, 2009 7:48 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 10:27 PM
Points: 87, Visits: 161
Great Article, Since most DBA's responsiblity is supporting\troubleshooting such a complex product like SQL server you have highlighted a good methodology and approach to problem solving, Thanks !


Post #688895
Posted Thursday, April 2, 2009 7:51 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:49 PM
Points: 389, Visits: 1,042
Excellent article Mike!

I really like your writing style, and you have some cool things to say. Troubleshooting is about as scientific as our jobs get and I appreciate your application of the scientific method.

:{> Andy


Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #688903
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse