SQL Server Triage – Where to Start?

Featured Article(s)
Oracle 11g Software Installation on LinuxCentOS-5
After going through the 2-Day DBA guide and talking about installing Oracle software, I thought it would be interesting to write an article that covered an actuall install of Oracle 11g on Linux–CentOS-5.

Thanks To Our Sponsors
We’ve worked with some great companies this year! We really appreciate their support and help in bringing you SSWUG. Over the next few days I’ll be bringing you a list of the different sponsors, big and small. Take a moment and check it out – there are some outstanding products here!

Resonate – Keeping Your Business Open for Business
Scalability Experts – SQL Server 2000 & 2005 Consulting & Training
SoftTree Technologies – Developer Task Scheduling, Auditing & Compliance Tools
SoftwareFX – Essential Data Visualization Solutions
Solid Quality Mentors – Training That Offers More
SPI Dynamics – Start Secure. Stay Secure

Bleary Eyed SQL Server DBA Needs Help Knowing Where to Start
At least weekly I receive emails asking "where do I start???" Not in a "Day 1 as DBA" kind of way, but more in looking at all there is to consider, where to get going. Usually we’ll suggest that they get started getting to know their systems – find out about instances that are running, basic configuration and baseline type information about performance, resources available and such.

Sometimes though, we get requests from people that are not only dropped into working with and managing SQL Server, but they’re faced with their first SQL Server and their first triage situation, all at the same time. Ugh. Talk about bath by fire!

It’s hard to suggest that someone take a deep breath and step back from the situation and try to get an understanding of the system before doing anything when the whole reason they were put into the SQL Server role was to address a serious issue that’s happening right now.

Do you have a checklist of things you do when you’re in triage mode on a new server? Do you have one or two steps that are your educated guesses at what types of things to look at? Drop me a note – how would you approach "omigoshwehaveneverneededaDBAbeforethisbutareindeeptroublesohurryupandfixit…NOW!" type situations.

Please email me here with your thoughts.

Latest SQL Server Show Live Now
This SQL Server show has a LOT of information. Interviews with some tools makers, information about protecting your holiday time, 60 second tip of the day, our SQL Server discussion list watch and a whole lot more.

> Watch Now

Also available
Watch: SQLonCall Show – Interviews and more.

Featured White Paper(s)
The Shortcut Guide to SQL Server Infrastructure Optimization
In The Shortcut Guide to SQL Server Infrastructure Optimization, the new eBook from Realtime Publishers, leading IT author Do… (read more)

Profiling SQL Server Performance by Kevin Kline
Database changes impact database performance. The challenge is that DBAs lack the necessary expertise and cannot afford the o… (read more)

Top Ten Steps to Secure Your SQL Server
In most organizations today, business critical and confidential data increasingly resides in Microsoft SQL Server databases. … (read more)