343: A Guide to Troubleshooting
Peter Smith , NBS Consulting Solutions    Biography

Objectives: Impart some of my monitoring techniques
troubleshooting skills
stories of failures turning into successes
Abstract: Everybody from the unskilled user to Network Administrator and Developer will blame the database FIRST. It is something which all DBAs need to get used to. The database is the keeper of the data, so if a person can't get what they want, then the source is blamed. As the keeper of the database, it falls to the DBA to stay professional, remain calm, find the true source of the problem.

Finding the source of a problem first requires knowing there is a problem. It is preferable to be proactive and monitor for issues rather than waiting for the bosses latest flaming email to arrive.

Resolving a problem will require a broad knowledge of technology, data, and the application. A little Java and Application Server knowledge can go a long way. Knowing how things are supposed to work helps to pinpoint the source of the problem.

I'll try to impart how I approach problems, the tools I use and the thought processes utilized to find solutions.

Audiernce Focus: Developers
Expertise: Beginner
Track: Database
Date: Wednesday, April 16, 2008
Time: 3:15 PM - 4:15 PM