Sybase ASE 12.5 Performance Optimization

Author: (USA) Garbus (Garbus/J.) et al. / Zhang Chongwen et al.
Publisher:
Publish Date: 2005-01-01
Features: This book provides a comprehensive guide for the entire Sybase server performance optimization process, from standard systems and optimizing stored procedures to using sp_sysmon for monitoring. Its main content includes defining performance, understanding I/O operations, using the query optimizer, managing memory, and handling queries. Additionally, it discusses application design, deadlocks and locks, performance benchmarks, auditing systems, and practical techniques for resolving blocking system issues. For anyone looking to optimize their server performance, this book is an essential practical reference manual. It is tailored for Sybase database administrators and technical consultants.