Blog Introduction

Hello Everyone,

It's been a while that I have been working with SQL Server. One of biggest challenge that I have seen people face is with troubleshooting is that people are at a loss to where to look and what to collect.

If you know what data to collect and how to collect, that's half your solution. Two reasons for this:

1. Too much unnecessary information can divert you in the wrong direction
2. Troubleshooting becomes much simpler with relevant data collection

So, in this blog we are going to cover two aspects of maintaining SQL Serves:

1. Pro-active work which will help us minimize points of failure and narrow down to the root if a problem does occur
2. Re-active work which involves having the right approach and action plan ready in case a problem does appear

All comments are most welcome.

Two of the best resources for Troubleshooting SQL Server Issues is:

1. Technet Forums
2. SQL 2005 Practical Troubleshooting: The Database Engine by Ken Henderson (This is a must read. This is same author for Guru's Guide to SQL Server. This book has inputs from the DEV team for SQL Server)
http://www.khen.com/2007/06/sql-server-2005-practical.html
http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743