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.
FREE Two-Day Shipping for students on millions of items. Learn more |
| ||||||||||||
Book Description
Special Offers and Product Promotions
- Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)
Frequently Bought Together
Editorial Reviews
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
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
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,
By
Amazon Verified Purchase(What's this?)
This review is from: The Official Guide: Sybase ASE 12.5 Performance and Tuning (Jeffrey Garbus' Official Sybase ASE 12.5 Library) (Paperback)
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,
By A Customer
This review is from: The Official Guide: Sybase ASE 12.5 Performance and Tuning (Jeffrey Garbus' Official Sybase ASE 12.5 Library) (Paperback)
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,
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.
Share your thoughts with other customers: Create your own review
|
|
Inside This Book
(learn more)
First Sentence:
How do you define performance? Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
sysmon output, abstract query plans, column level statistics, semaphore contention, asynchronous prefetch, statistics table name, total logical memory, sybsecurity database, total density value, polling process count, log semaphore, user log cache, max parallel degree, sysmon report, xact count, audit queue, max online engines, semaphore requests, named caches, page utilization percent, spinlock ratio, range cell density, spinlock contention, disk array vendors, deleting statistics Key Phrases - Capitalized Phrases (CAPs): (learn more)
Adaptive Server, The Complete Works, Ndx Maint, The Optimizer Statistics, Optimizing Stored Procedures, System Security Officer, Parallel Query Processing, Total Cache Searches, Cache Search Misses, Checks Returning, Grabbed Dirty, Log Semaphore Contention, Logical Volume Manager, Physical Database Design Issues, Storage Area Network, Group Commit Sleeps, Max Outstanding, Total Bytes Sent, Total Cache Misses, Total Large, Arbitrated Loop, Avg Disk, Buffers Found, Cache Statistics Summary, Last Log Page Writes New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
How do you define performance? Read the first page Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
sysmon output, abstract query plans, column level statistics, semaphore contention, asynchronous prefetch, statistics table name, total logical memory, sybsecurity database, total density value, polling process count, log semaphore, user log cache, max parallel degree, sysmon report, xact count, audit queue, max online engines, semaphore requests, named caches, page utilization percent, spinlock ratio, range cell density, spinlock contention, disk array vendors, deleting statistics Key Phrases - Capitalized Phrases (CAPs): (learn more)
Adaptive Server, The Complete Works, Ndx Maint, The Optimizer Statistics, Optimizing Stored Procedures, System Security Officer, Parallel Query Processing, Total Cache Searches, Cache Search Misses, Checks Returning, Grabbed Dirty, Log Semaphore Contention, Logical Volume Manager, Physical Database Design Issues, Storage Area Network, Group Commit Sleeps, Max Outstanding, Total Bytes Sent, Total Cache Misses, Total Large, Arbitrated Loop, Avg Disk, Buffers Found, Cache Statistics Summary, Last Log Page Writes New!
Books on Related Topics | Concordance | Text Stats Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Citations (learn more)
This book cites 1
book:
2
books
cite this book:
- Installation Guide by Sun Microsystems Inc. in Back Matter
Books on Related Topics
(learn more)
|
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
