Sybase System XI: Performance Tuning Strategies - Couverture rigide

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

Couverture rigide

ISBN 10 : 0134948653 ISBN 13 : 9780134948652

Editeur : Prentice Hall, 1996

Synopsis

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.

A propos du livre

À propos de la quatrième de couverture

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.

Détails de l'édition

• Éditeur: Prentice Hall
• Date d'édition: 1996
• Langue: anglais
• ISBN 10: 0134948653
• ISBN 13: 9780134948652
• Reliure: Relié
• Nombre de pages: 176
• Coordonnées du fabricant: non disponible
• Personne responsable: non disponible