Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Ships from and sold by Amazon.ca. Gift-wrap available.
Microsoft SQL Server 2000... has been added to your Cart
+ CDN$ 6.49 shipping
Used: Good | Details
Sold by bwbuk_ltd
Condition: Used: Good
Comment: Ships from the UK. Former Library book. Shows some signs of wear, and may have some markings on the inside. 100% Money Back Guarantee. Your purchase also supports literacy charities.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft SQL Server 2000 Performance Tuning Technical Reference Hardcover – Jul 3 2001

4.4 out of 5 stars 7 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 52.99
CDN$ 52.99 CDN$ 0.01

Save an Additional 10% on Textbooks When you Join Amazon Student

Special Offers and Product Promotions

  • Amazon Student members save an additional 10% on Textbooks with promo code TEXTBOOK10. Enter code TEXTBOOK10 at checkout. Here's how (restrictions apply)

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your e-mail address or mobile phone number.

Product Details

  • Hardcover: 464 pages
  • Publisher: Microsoft Press; 1 edition (July 3 2001)
  • Language: English
  • ISBN-10: 0735612706
  • ISBN-13: 978-0735612709
  • Product Dimensions: 18.7 x 3.6 x 23.5 cm
  • Shipping Weight: 1.1 Kg
  • Average Customer Review: 4.4 out of 5 stars 7 customer reviews
  • Amazon Bestsellers Rank: #2,590,796 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From Amazon

Tuning databases can be fun if built into the predeployment time allocated to building a system. Tuning ceases to be fun when it's undertaken on a production system, overseen by an unhappy customer with crushing time constraints. Unfortunately, the latter scenario tends to be the more common. Microsoft SQL Server 2000 Performance Tuning Technical Reference provides database administrators and (to a lesser degree) developers with the information they need to extract maximum performance from Microsoft SQL Server 2000. This book favors optimization of SQL Server that can be done via the administrative interface rather than in application code.

Most of database tuning has to do with sacrificing one aspect of performance (say, disk storage capacity) for the improvement of another (like the execution speed of a particular kind of query). The authors of this book--they're a team of consultants from a Texas company that specializes in database tuning, as well as from Microsoft--take care to explain the tradeoffs involved in various tuning decisions. Choose one option, they say, and performance metric A will improve at the expense of metric B. Having explained the design considerations for various tuning strategies, they walk their readers through how to do the tuning they're talking about. Instructions aren't for the clueless, but they're fully adequate for SQL Server users who know their way around the interface generally. --David Wall

Topics covered: How to make databases served by Microsoft SQL Server 2000 run as fast and as efficiently as possible by tweaking the way it runs. Emphasis is placed on read/write operations (including SQL Server's way of interacting with RAID arrays), performance monitors, and settings for processor, disk, and RAM usage. There's also a lot of information on capacity planning and system sizing.

About the Author

Edward Whalen is an expert in database performance, administration, and backup recovery solutions.

Inside This Book

(Learn More)
First Sentence
Performance tuning, capacity planning, and sizing are exciting subjects, offering a great deal of variety and new learning experiences. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.4 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 7 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Hardcover
I bought this book on the basis of the glowing recommendations here. As I have a number of servers to tune which execute some extremely complex SQL, and I need to be able to look inside with Perfmon and the profiler, I thought this book would be very useful. I particularly wanted help with sysmon.
This book gave me virtually nothing. Its coverage of tuning was shallow, information was repeated unnecessarily, text was copied almost verbatim from BOL, and it provided little or nothing that couldn't be found elsewhere and easily.
It tries to cover everything at the cost of giving real value. For example it provides 15 pages on data warehousing of which 12 are a description of data warehousing so cursory that if you don't know the subject you'll only be confused, and 3 pages on actual tuning which basically say that you should find out whether the bottleneck is CPU/disk/memory then add more CPU/disk/memory respectively.
Sizing and capacity planning are introduced with seven equations without justification. Okay, but completions C is given as the number of transactions that were completed during the observation period, but on the facing page C = 96 seconds [sic]. Did anyone proof-read this? With these and numerous other oddities (trunc. log on chkpt on SQL2000?) I don't know what I can trust.
The mathematics for this section is done and finished in 6 pages.
I was particularly looking for a comprehensive description of sysmon counters. Other than a quick rundown of the obvious ones there's a long list in the appendix of others, including such gems as "lock blocks allocated: the total number of allocated lock blocks". The whole point of buying this book was to find out how to use them, or indeed what they mean (Skipped Ghosted Records/Sec - means what?
Read more ›
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Hardcover
I tell my clients and users that the two most important services that a DBA provides are security and performance, but not necessarily in that order. If you are a professional SQL Server DBA or a DBA wannabe, performance has to be one of your top skills.

This book, by Edward Whalen, gives you the information that you will need to accomplish the very important task of planning a new SQL Server installation. There is a lot of very useful discussion that relate the physical hardware parameters of the server to the expected performance that users will experience. This discussion includes a comprehensive survey of how the I/O subsytem contributes to the overall server performance. There are also two chapters on sizing and capacity planning, with carefully worked-through examples detailing how to size memory and how to determine appropriate disk and processor configurations for a new installation.
Of course, the other major task in the performance arena is troubleshooting. Although Whalen's book doesn't present a performance troubleshooting checklist, the major theme of this book centers on recognizing and remediating performance problems. In many cases, the book also discusses the origins of the preformance problems. By the time you internalize this book, you'll be able write your own troubleshooting checklist.
In my opinion, the two best aspects of this book are:
a) Unlike some other "Performance" books that I have read, this book focuses on performance and not a million other things. It discusses performance, not DTS, not Security, not Internet, etc. It just talks about performance.
b) With the Acknowledgments section thanking Bill Gates twice, and this book being written by Microsoft insiders, I would have expected lots of hype.
Read more ›
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Hardcover
Considering the difficulty of the topic, this book is a fairly easy read. The single best thing about the book is that the advice is actionable. You can read this book and immediately begin tuning.
Coverage is excellent - performance tuning, capacity planning, setting up disk drives, managing cpu, I/O, network, and memory, index tuning, backups, replication, OLTP versus OLAP, etc.
For each subject area, the authors explain the applicable concepts and SQL Server tools, and then systematically explain their application using practical examples.
Compared to other performance tuning books, it is an 80/20 book. By this I mean that the authors focus on what is most important and then move on to the next topic. They don't get carried away demonstrating how much they know about each concept or go into the minutia of the options of each SQL Server tool.
I hope they write more books.
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse
Format: Hardcover
Strong recommendations from others brought me to this book and I feel obliged to give back.
This is a masterpiece.Well researched and well written
I Got a hold of a couple of concepts missed in other books because of the lucidity of the examples and explanations.
Great book If you read it you will understand why....
Michael Tubuo Ngong
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse