Configuring and Tuning Databases on the Solaris Platform (Sun Microsystems Press)

Configuring and Tuning Databases on the Solaris Platform (Sun Microsystems Press)

by SunMicrosystemsPress (Author), Allan N . Packer (Author)

Synopsis

Using this book, database professionals can dramatically improve the performance and cost-effectiveness of virtually any database application running on the Solaris (R) platform. Solaris database optimization specialist Allan Packer presents start-to-finish guidance on optimizing all four leading Solaris databases: Oracle, DB2, Sybase, and Informix. Configuring and Tuning Databases on the Solaris Platform brings together best-practice guidelines for every aspect of database tuning on Sun servers. Drawing on years of expertise as a Sun consultant, Packer presents detailed recommendations for data layout, CPU and memory configuration, and system sizing. He introduces a systematic, drill-down monitoring approach designed to help database professionals identify and resolve system bottlenecks that inhibit database performance. Packer demystifies database tuning by providing a quick primer that explains database architecture, key database concepts, and how to use key subsystems such as query optimizers and buffer cache. He describes and critiques each leading database benchmark, offering guidance for using benchmarks -- and not misusing them.

$54.72

Quantity

2 in stock

More Information

Format: Paperback
Pages: 552
Edition: 1
Publisher: Prentice Hall
Published: 26 Nov 2001

ISBN 10: 0130834173
ISBN 13: 9780130834171
Book Overview:

Using this book, database professionals can dramatically improve the performance and cost-effectiveness of virtually any database application running on the Solaris (R) platform. Solaris database optimization specialist Allan Packer presents start-to-finish guidance on optimizing all four leading Solaris databases: Oracle, DB2, Sybase, and Informix. Configuring and Tuning Databases on the Solaris Platform brings together best-practice guidelines for every aspect of database tuning on Sun servers. Drawing on years of expertise as a Sun consultant, Packer presents detailed recommendations for data layout, CPU and memory configuration, and system sizing. He introduces a systematic, drill-down monitoring approach designed to help database professionals identify and resolve system bottlenecks that inhibit database performance. Packer demystifies database tuning by providing a quick primer that explains database architecture, key database concepts, and how to use key subsystems such as query optimizers and buffer cache. He describes and critiques each leading database benchmark, offering guidance for using benchmarks -- and not misusing them.


Author Bio

ALLAN PACKER is a Senior Staff Engineer with the Performance and Availability Engineering Group at Sun Microsystems. He has developed workloads for performance and regression testing, led the engineering team working with IBM DB2, acted as technical lead for nine published TPC benchmark results, and developed a training curriculum for the internal training organization focused on configuring, monitoring and tuning database systems. He currently specializes in server systems performance and availability.