Sybase System XI: Performance Tuning Strategies - Rilegato

Phillips, Ronald A.; O'Neil, Bonnie K.; Brain, Marshall

Rilegato

ISBN 10: 0134948653 ISBN 13: 9780134948652

Casa editrice: Prentice Hall Ptr, 1996

Riassunto

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.

Su questo libro

Dalla quarta di copertina

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.

Product Description

Book by Phillips Ronald A ONeil Bonnie K Brain Marshall

Dettagli dell'edizione

• Editore: Prentice Hall Ptr
• Data di pubblicazione: 1996
• Lingua: Inglese
• ISBN 10: 0134948653
• ISBN 13: 9780134948652
• Rilegatura: Copertina rigida
• Numero di pagine: 158
• Contatto del produttore: non disponibile
• Persona responsabile: Yeepin GmbH; 492000000000; sunshine12232@outlook.com; ; Alleestr.11; Kaiserslautern; Rheinland-Pfalz; 67655; Germania