Publisher's Synopsis
Book & CD. Once your database system is up and running, you need to keep it functioning smoothly. Designed for the DBA working to maximise the performance of a Sybase server, this book provides a guide to this important process. From benchmarking your system and optimising 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 optimiser, 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 maximising server performance. The companion CD-ROM contains ASE 12.5 NT Developer's Edition.
