question

Tim avatar image
Tim asked

Triage check list for SQL Server

So you get a call any time during the day, lets not just pretend it is 3:00 AM. You get the typical call that either users can't connect, the server is slow, etc etc. I am wanting to put together a general check list for my dba's and especially on call dba to go through anytime they get called for a critical system down situation. Some examples SQL Server Log - failed logins, SQL errors Windows Event Log - Services stopped, system errors, alerts Check for blocking SP_Whoisactive Performance Counters - CPU, Memory, Disk Page Life Expectancy, did something just flush the cache and you are in seconds? and so forth. Would love real world examples of how some of these things saved your neck.
performancedbaadministration
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee avatar image
raadee answered
I use Brent Ozar's checklist as a template. [ozar template][1] I add a couple of steps for virtualization issues. I once got a call about a sql server (vmware) that stopped working. Could not connect to the server over the network, launched the console and I could not find any network errors on the server. Sql was up and running. Almost thought it was a prank.. Picked up the phone and called mr virtualization and what do tou know, my server was accidentaly moved to a host where the network was not configured.. So I moved it to a another host, instantly started working. Updated my checklist with "vmware host connectivity steps". [1]: http://cdn.prod.brentozar.com/wp-content/uploads/2011/12/SQLServerTroubleshootingChecklist.pdf
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
I don't have a solid checklist myself, but I'd suggest reading through Troubleshooting [for the Accidental DBA][1]. I'm pretty sure Jonathan and Ted have something useful to say about it. [1]: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.