|
The Official Guide: Sybase ASE 12.5 Performance & Tuning
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, 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.
This book is a must for those who are responsible for maximizing server performance.
The companion CD-ROM contains ASE 12.5 NT Developer's Edition.
Introduction
Physical database design issues
I/O
Indexes
The optimizer statistics
Cache strategies
Parallel query processing
Application design
T-SQL programming
Locking
Deadlock
Configuration
Network performance
The audit system
Abstract query plans
CD contains ASE 12.5 NT developers edition
|
