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.
