Cary Millsap - Böcker

This text dispenses with database-centric metrics and instead shows how to use Oracle's response time statistics to diagnose performance problems in an Oracle application system. Former VP of Oracle's System Performance Group, Cary Millsap, clearly shows how eliminating requests for unneeded work improves performance dramatically. He also shows how the mathematical discipline of queueing theory can be combined with response time metrics to accurately predict the impact of system changes and upgrades. This text clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. It also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes. The book aims to eliminate the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance,where it is not, in just a few minutes - even if the problem is several years old.It also intends to cut a path through the complexity of current tuning methods, and streamline an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable - even dramatic - improvements. For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.

Slow systems are frustrating. They waste time and money. But making consistently great decisions about performance can be easy, if you understand what's going on. This book explains in a clear and thoughtful voice why systems perform the way they do. It's for anybody who's curious about how computer programs and other processes use their time and about what you can do to improve them.Through a mix of personal vignettes and technical use cases, Cary Millsap reviews the process of improving performance and provides best practices for optimizing systems efficiently. You'll learn how to identify the information needed to improve a system, how to find the root causes of performance issues, and how to fix them. You'll also learn how performance optimization is both a skill set and a mindset, and how to develop both over time.If you're a computer professional whose success relies on software that goes fast, by the end of this book you'll be able to identify, view, scope, analyze, and remedy performance issues with consistency and confidence.