Sybase System XI: Performance Tuning Strategies - Hardcover

Von der hinteren Coverseite

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.