Sybase System XI: Performance Tuning Strategies - Hardcover

Phillips, Ronald ; O'Neil, Bonnie ; Brain, Marshall

9780134948652: Sybase System XI: Performance Tuning Strategies

Hardcover

ISBN 10: 0134948653 ISBN 13: 9780134948652

Publisher: Prentice Hall, 1996

View all copies of this ISBN edition

4 Used

From � 6.13

0 New

The book allows database programmers to confidently and efficiently tune Sybase applications and servers for maximum performance. This book presents an overview of the discipline of performance tuning; then offers practical strategies, theories, tools, and techniques. It shows developers how to plan and build systems that offer maximum performance from the outset. It describes typical performance problems that arise in real environments, and shows how to eliminate them. Among the topics covered are: the Sybase optimizer, execution thread analysis, indexes, table locking and concurrency controls, query strategies and tactics, and memory use.

"synopsis" may belong to another edition of this title.

From the Back Cover

49486-4

This book will deliver a robust understanding of the Sybase� architecture, especially the new enhancements in System XI, giving the programmer or database analyst the mental framework necessary to truly understand all the factors that comprise performance tuning.

With these tools you can analyze, prevent, or eliminate a number of important performance problems that arise in real environments. Proactive planning is essential, and proper design strategies are stressed so that performance is built into the system from the very beginning. While it is simple to design a prototype database, it is much harder to design a database that works well under the heavy load seen in a normal production environment.

With this book you will learn:

Useful troubleshooting techniques to correct problems when your database application performs poorly.
How to build high performance in every aspect of the design in a short time frame.
How to maintain somebody else's horrible, poor-performing code―the do's and don'ts that can greatly affect performance of an SQL statement.
How the optimizer works, so that you can use it to maximum advantage.
Good index strategies and good SQL techniques that can help compensate for poor design.

"About this title" may belong to another edition of this title.