Sybase ASE 12.5 Performance and Tuning: The Official Guide (Jeffrey Garbus' Official Sybase ASE 12.5 Library) - Softcover

Garbus, Jeffrey; Etc.

Softcover

ISBN 10: 1556229089 ISBN 13: 9781556229084

Publisher: Wordware Publishing Inc., 2002

Synopsis

Designed for the administrator working to maximize the performance of a Sybase Server, this book walks readers through tuning their system from setting the right expectation to TSQL coding techniques.

About this title

Synopsis

This title is available in a book and CD format. 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.

Edition details

• Publisher: Wordware Publishing Inc.
• Publication date: 2002
• Language: English
• ISBN 10: 1556229089
• ISBN 13: 9781556229084
• Binding: Paperback
• Number of pages: 413