Configuring and tuning databases on the Solaris platform

1st Edition

By Allan N. Packer

ISBN: 0130834173
Publisher: Prentice Hall
Year: 2002
Pages: 502

About This Book

Using this book, database professionals can dramatically improve the performance and cost-effectiveness of virtually any database application running on the SolarisA (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.

Product Details

Publisher Prentice Hall
Publication date January 1, 2002
Language English
Print length 502 pages
ISBN-10 0130834173
ISBN-13 978-0130834171
Item Weight 1.9 pounds

Editorial Reviews

Editorial Review

From the Back CoverTurbocharge your Oracle, DB2, Sybase, or Informix database environment! Turbocharge your Oracle, DB2, Sybase, or Informix database environment! Covers every aspect of database and Solaris Operating Environment tuning Covers every aspect of database and Solaris Operating Environment tuning Optimize data layout, CPU and memory configuration, and system sizing Optimize data layout, CPU and memory configuration, and system sizing Identify and resolve bottlenecks, step-by-step Identify and resolve bottlenecks, step-by-step Understand industry-leading benchmarks Understand industry-leading benchmarks Maximize the performance of any enterprise database running on the Solaris Operating Environment!Maximize the performance of any enterprise database running on the Solaris Operating Environment!Using this book, database professionals can optimize the performance and cost-effectiveness of virtually any database application running on the Solaris platform. Database specialist Allan Packer presents start-to-finish guidance for optimizing all four leading Solaris platform databases: Oracle (including Oracle9i), DB2, Sybase, and Informix XPS. Drawing on years of expertise as an engineer at Sun, Packer brings together best-practice guidelines for every aspect of Sun database server tuning.Using this book, database professionals can optimize the performance and cost-effectiveness of virtually any database application running on the Solaris platform. Database specialist Allan Packer presents start-to-finish guidance for optimizing all four leading Solaris platform databases: Oracle (including Oracle9i), DB2, Sybase, and Informix XPS. Drawing on years of expertise as an engineer at Sun, Packer brings together best-practice guidelines for every aspect of Sun database server tuning.Optimizing data layout, CPU and memory configuration, and system sizing Optimizing data layout, CPU and memory configuration, and system sizing Identifying and resolving bottlenecks: a systematic, drill-down monitoring approachIdentifying and resolving bottlenecks: a systematic, drill-down monitoring approachUnderstanding database optimizers, database buffer cache, and other key subsystemsUnderstanding database optimizers, database buffer cache, and other key subsystemsDemystifying the industry's leading benchmarks-and recognizing their limitationsDemystifying the industry's leading benchmarks-and recognizing their limitationsUnderstanding the impact of Java technology on database application design Understanding the impact of Java technology on database application design Contains a quick primer on database architecture and concepts Contains a quick primer on database architecture and concepts About the AuthorALLAN 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 p
Shipping set per seller
Compare book + shipping totals for each offer
Seller-error returns
Returns accepted for seller errors. Ask the seller about change-of-mind returns
Partner purchases
MedicalBook.online handles payment, shipping and returns for its orders
Email Support
[email protected] for buyers and sellers