Databases Reference
In-Depth Information
9
Troubleshooting Methodology
and Practices
WHAT'S IN THIS CHAPTER?
➤
Methodology for troubleshooting
➤
Ten steps to troubleshooting success
➤
An approach to working on complex issues with teams
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
The
wrox.com
code downloads for this chapter are found at
www.wrox.com/remtitle
.
cgi?isbn=1118177657
on the Download Code tab. The code is in the Chapter 9 download
and individually named according to the names throughout the chapter.
INTRODUCTION
SQL Server is a complex product, often tightly integrated with mid-tier and end-user applica-
tions. Problems can be many and varied, and the scope of a database administrator (DBA) is
broad, covering storage, servers, networking, applications, and meeting business requirements.
DBAs often i nd themselves supporting third-party and in-house-developed applications with
varying levels of maturity and robustness. There are no i xed requirements for Transact-SQL
development, and application developers often overlook the performance and scalability of
code they write. This chapter provides DBAs with guidance based on mature patterns for
troubleshooting complex issues and complements the technical aspects of this topic.
Search WWH ::
Custom Search