Sybase ASE 12.5 Performance and Tuning

  • 6h 59m
  • Jeffrey Garbus, et al.
  • Jones and Bartlett Learning
  • 2003

Once your database system is up and running, you need to keep it functioning smoothly. Designed for the DBA working to maximize the performance of a Sybase server, Sybase ASE 12.5 Performance and Tuning provides a guide to this important process. From benchmarking your system and optimizing stores procedures to indexing and using sp_sysmon to monitor your system, the authors thoroughly explain how to tune your server for maximum performance.

Topics include defining performance, understanding the I/O system, using the query optimizer, managing memory, and processing queries. Additionally, the authors discuss application design, deadlocks and locking schemes, performance metrics, and auditing features, along with providing tips for solving problems that can bog down a system.

About the Authors

Jeffrey Garbus is a database consultant and the CEO of Soaring Eagle Consulting, Ltd., based in Tampa, Florida. He has spoken at user conferences, and has written many magazine articles and books. He is also lead author for Jeffrey Garbus' Official Sybase ASE 12.5 Library from Wordware Publishing, which includes Administrator's Guide to Sybase ASE 12.5 and Sybase ASE 12.5 High Availability.

Eric Miner works with the Sybase Optimizer Group in ASE Engineering.

Joel DuPlessis is a senior database consultant in New York.

Alvin Chang is a technical writer, author, and consultant working for Soaring Eagle Consulting.

Yuval Malchi is a database administrator and president of ISUG Israel.

In this Book

  • Sybase ASE 12.5 Performance and Tuning
  • Foreword
  • Introduction
  • Physical Database Design Issues
  • I/O — The Complete Works
  • Indexes
  • The Optimizer Statistics
  • ASE’s Optimizer
  • Cache Strategies
  • Parallel Query Processing
  • Application Design
  • T-SQL Programming
  • Optimizing Stored Procedures
  • Locking
  • Deadlock
  • Configuration
  • How to Read sp_sysmon Output
  • Network Performance
  • Performance Metrics
  • The Audit System
  • Abstract Query Plans
  • Miscellaneous Topics