Databases Reference
In-Depth Information
CHAPTER TEN
Troubleshooting
Perhaps you didn't get the opportunity to design the
database applications that are in production; you
just get the “opportunity” to maintain them and make
sure that the performance is acceptable. And you just
found out that the performance is unacceptable.
Or perhaps you did design the application, but after
benchmarking it, you aren't satisfied with the performance.
Whatever the scenario, this chapter walks you through how
to troubleshoot your performance issues and provides some
case studies that are similar to scenarios that we have
encountered in our years of helping people troubleshoot
their performance issues.
We recommend that you never deploy a critical applica-
tion without first running benchmarks to determine
whether performance is acceptable.
Read Chapter 9,
“Developing Good Benchmarks.”
In this chapter, we assume that your database is not the
issue, that it is tuned properly.
265
