Linux Debugging and Performance Tuning

Covering topics from analysis tools to kernel tuning, to capacity management, this book offers a single point of reference for what you need to know. Anyone who has ever had to speed existing operations or project usage patterns for future loads, knows that tracking down the relevant information can be a difficult task. That's why this book has been written-it pulls together all of this knowledge, saving countless hours of what might otherwise be wasted research time....

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside inde...

As today's IS departments move toward client/server environments, the demand and need for RDBMS performance tuning rapidly increases. This book is written to address that need and provide system administrators the detailed information they need to effectively maintain an efficient RDBMS.-- Shows readers how to design an efficient client/server environment-- Teaches ways to fine tune legacy systems-- CD-ROM includes source code from the book and various powerful utilities...