Download or read book Sybase ASE 12.5 Performance and Tuning written by Jeffrey R. Garbus and published by Jones & Bartlett Publishers. This book was released on 2002-08 with total page 448 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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 stored 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, processing queries, application design, deadlocks and locking schemes, performance metrics, auditing features, tips for solving problems that can bog down a system.