Free Downloads

Configuring And Tuning Databases On The Solaris Platform

Turbocharge your Oracle, DB2, Sybase, or Informix database environment! Covers every aspect of database and Solaris Operating Environment tuning Optimize data layout, CPU and memory configuration, and system sizing Identify and resolve bottlenecks, step-by-step Understand industry-leading benchmarks 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. Optimizing data layout, CPU and memory configuration, and system sizing Identifying and resolving bottlenecks: a systematic, drill-down monitoring approach Understanding database optimizers, database buffer cache, and other key subsystems Demystifying the industry''s leading benchmarks-and recognizing their limitations Understanding the impact of Java technology on database application design Contains a quick primer on database architecture and concepts

Paperback: 552 pages

Publisher: Prentice Hall; 1 edition (December 6, 2001)

Language: English

ISBN-10: 0130834173

ISBN-13: 978-0130834171

Product Dimensions: 6.9 x 1.3 x 9 inches

Shipping Weight: 2 pounds (View shipping rates and policies)

Average Customer Review: 4.7 out of 5 stars  See all reviews (7 customer reviews)

Best Sellers Rank: #917,478 in Books (See Top 100 in Books) #14 in Books > Computers & Technology > Operating Systems > Solaris #152 in Books > Computers & Technology > Programming > Software Design, Testing & Engineering > Structured Design #330 in Books > Computers & Technology > Operating Systems > Unix

Don't be deceived by the title. Although this gem focuses on Sun's Solaris operating system, which is a widely used flavor of Unix, much of it is applicable to AIX, HP-UX, Linux, etc. Packer's considerable breadth and depth of knowledge and experience show on every page. He shares a discipline with his readers that enables them to configure and tune their databases and operating systems.A sampling of headers illustrates the broad, ambitious scope of the book. Topics include SMP, NUMA, Clusters, tuning the buffer cache, database optimizers, OLTP, DSS, memory management, logical and physical storage, system sizing and capacity planning, high availability, performance troubleshooing, measurement tools and analysis, database and system tuning guidance, scalability, strengths and weaknesses of the TPC benchmarks, etc. Packer successfully covers his material by focusing attention on what he has found to work and has a significant performance impact. Many of these are found in rules of thumb that are generously sprinkled throughout the book.Packer shares a layered approach to a complex subject. He builds an architectural foundation (operating system fundamentals and RDBMS internals). His database discussion is limited to Oracle, DB2, Sybase, and Informix. If one uses another product, his discussion should highlight architectural areas that should be understood by system administrators or database administrators (who all too frequently understand their domain but not the other's). The same level of product understanding is necessary to configure and tune other products for performance. Packer builds on a architectural foundation with metrics and analysis. He presents a methodology that is pragmatic and efficient.

Configuring and Tuning Databases on the Solaris Platform Solaris Performance and Tools: DTrace and MDB Techniques for Solaris 10 and OpenSolaris (paperback) Oracle Solaris and Veritas Cluster : An Easy-build Guide: A try-at-home, practical guide to implementing Oracle/Solaris and Veritas clustering using a desktop or laptop DTrace: Dynamic Tracing in Oracle Solaris, Mac OS X, and FreeBSD (Oracle Solaris Series) Solaris Internals: Solaris 10 and OpenSolaris Kernel Architecture (2nd Edition) Solaris 10 ZFS Essentials (Oracle Solaris System Administration Series) Oracle Solaris Cluster Essentials (Oracle Solaris System Administration Series) Solaris 10 System Administration Essentials (Oracle Solaris System Administration Series) Solaris 10 Security Essentials (Oracle Solaris System Administration Series) App Inventor 2: Databases and Files: Step-by-step TinyDB, TinyWebDB, Fusion Tables and Files (Pevest Guides to App Inventor Book 3) Practical PHP and MySQL Website Databases: A Simplified Approach (Expert's Voice in Web Development) Next Generation Databases: NoSQL, NewSQL, and Big Data Configuring Cisco Unified Communications Manager and Unity Connection: A Step-by-Step Guide (2nd Edition) (Cisco Press Networking Technology) Configuring Cisco Unified Communications Manager and Unity Connection: A Step-by-Step Guide (Networking Technology: IP Communications) Podcasting Like a Pro with GarageBand '11 (The Down & Dirty Series): Configuring GarageBand '11 for advanced podcast recording and universal production techniques for other platforms. MCSA/MCSE Self-Paced Training Kit (Exam 70-270): Installing, Configuring, and Administering Microsoft® Windows® XP Professional: Installing, ... Second Edition (Pro-Certification) Quantitative Electroencephalographic Analysis (QEEG) Databases for Neurotherapy: Description, Validation, and Application 70-687 Configuring Windows 8.1 Graph Databases: New Opportunities for Connected Data Data Management: Databases & Organizations