The Official Guide: Sybase ASE 12.5 Performance and Tuning (Jeffrey Garbus' Official Sybase Ase 12.5 Library) (Paperback)

by Jeffrey Garbus (Author) "How do you define performance?..." (more)
Key Phrases: sysmon output, abstract query plans, column level statistics, Adaptive Server, The Complete Works, Ndx Maint (more...)

Editorial Reviews

Product Description
Once your database system is up and running, you need to keep it functioning smoothly. Designed for the DBA working to maximize the performance of a Sybase server, Sybase ASE 12.5 Performance and Tuning provides a guide to this important process. From benchmarking your system and optimizing stored procedures to indexing and using sp_sysmon to monitor your system, the authors thoroughly explain how to tune your server for maximum performance. Topics include defining performance, understanding the I/O system, using the query optimizer, managing memory, and processing queries. Additionally, the authors discuss application design, deadlocks and locking schemes, performance metrics, and auditing features, along with providing tips for solving problems that can bog down a system.

About the Author
Jeffrey Garbus is a database consultant and the CEO of Soaring Eagle Consulting, Ltd.He has spoken at user conferences, and has written many magazine articles and books. He is also the lead author for Jeffrey Garbus’ Official Sybase ASE 12.5 Library from Wordware Publishing, which includes Administrator’s Guide to Sybase ASE 12.5 and Sybase ASE 12.5 High Availability.

Eric Miner works with the Sybase Optimizer Group in ASE Engineering. Joel DuPlessis is a senior database consultant in New York. Alvin Chang is a technical writer, author, and consultant working for Soaring Eagle Consulting. Yuval Malchi is a database administrator and president of ISUG Israel.

Product Details

• Paperback: 413 pages
• Publisher: Jones & Bartlett Publishers (August 25, 2002)
• Language: English
• ISBN-10: 1556229089
• ISBN-13: 978-1556229084
• Product Dimensions: 9.1 x 7.5 x 1.3 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.2 out of 5 stars See all reviews (4 customer reviews)
• Amazon.com Sales Rank: #291,742 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #5 in

  Books > Computers & Internet > Databases > SQL > Sybase

Customer Reviews

Most Helpful Customer Reviews

9 of 10 people found the following review helpful:

1.0 out of 5 stars DO NOT BUY - This book is not useful, November 9, 2004

By	Paul Filipski (Boston, MA USA) - See all my reviews (REAL NAME)

Mostly, this book is simply a rehash of material that is presented better in Sybase's own Performance & Tuning guide.

Sybase ASE 12.5 Performance and Tuning presents little if any useful tuning advice. What advice is present ranges from flat out wrong (e.g. "If Cache Search Misses falls below 20%, consider adding physical memory" - page 288) to mystically useless (e.g. "Create and use temp tables outside of each other" - page 228).

Further, the depth of coverage is quite poor. For example, there are only thirteen pages dedicated to locking, four to tempdb, and just one for log management (yes, only one page discussing logs!!).

Finally, Sybase ASE 12.5 Performance and Tuning has many grammatical mistakes. Typically I can look past such a minor annoyance, but with this book's limited utility, this is the final slap in the face.

5 of 6 people found the following review helpful:

4.0 out of 5 stars An excellent resource, January 15, 2004

By A Customer

This book answers all the really tough questions in very clear and simple ways. Much of the info in this book is the sort of stuff you're only lucky enough to get if you happen to have a Sybase performance expert onsite. If you've ever found yourself with a really tricky performance question you know what a good thing it is to find information about Sybase monitoring tools and performance troubleshooting all in a single book. This book appears to have been written by people with much experience in troubleshooting performance problems and the advice is about the best you're going to get anywhere.

4 of 5 people found the following review helpful:

5.0 out of 5 stars Excellent introduction to Sybase HA, September 13, 2004

By	horati "dba" (New York, NY) - See all my reviews

This review is from: Sybase ASE 12.5 High Availability, The Official Guide (Jeffrey Garbus' Official Sybase ASE 12.5 Library) (Paperback)

This book is an excellent introduction to the subject of how Companion Server, Replication Server and Open Switch work together. It also covers software pros and cons to help you make business decisions on its implementation. This book is very easy to read and has real life practical tips and suggestions at the end. A good overall "how to" book. There should be more technical books out there written like this.