Sybase System XI Performance Tuning Strategies

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.