Chapter 18. Troubleshooting Methods

Imagine you are a performance consultant. You find yourself visiting a Sun customer with a major database application. On your way to the coffee machine a couple of anxious system administrators stop you in the hallway. “Our database server is performing badly. Can you look at it?” they plead.

What process would you go through to track down the problem? I routinely ask this question when interviewing candidates for our group (Performance and Availability Engineering at Sun). I receive some surprising answers.

Candidates fresh from college typically want to dive straight into the database or operating system source code and implement traces to monitor mutex contention for the critical sections of code. If that ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.