 See larger picture | Microsoft SQL Server 2000(TM) Performance Tuning Technical Reference (Pro-Technical Refere)
by
Edward Whalen, Marcilina Garcia, Steve Adrien DeLuca, and Dean Thompson
by MSOFTList Price: $49.99
Price at Amazon.com: $32.99
(Save
34%)
 Availability: Usually ships in 24 hours
Shipping rates and policies |
- Average Customer Review:
Based on
9
reviews.
- Amazon.com Sales Rank: 707931
|
Product Description MICROSOFT SQL SERVER 2000 PERFORMANCE TUNING TECHNICAL REFERENCE provides all the information that developers and database administrators need to configure Microsoft SQL Server 2000 for optimum performance and scalability. Unlike other SQL Server 2000 tuning books on the market, it teaches not just about the SQL Server relational database management system, but also about how to get the most out of the underlying operating system and hardware. The advanced information it presents is easy to grasp because the authors start with the basics and build upon information in previous chapters to teach the mechanics of performance tuning and how they affect the whole system. This title has been thoroughly revised since the last edition and includes new information throughout.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.
Featured Customer Reviews Good book to have just for reference,
January 31, 2006 Had this book for a while and only used it for couple times. I found some scripts that are useful for me in Chapter 17 (Tuning SQL Statements and Stored Procedures). I wrote two scripts which I assigned the jobs on SQL Server Agent and allow the Agent do its work at 3 a.m every day when the average connections between 5 to 10 concurrent users. The book does covered other areas such as system I.O (Hardware & RAID configuration) and SQL Analyzer which I already know. I would recommand other book over this one (Microsoft SQL Server 2000 Administrator's Pocket Consultant-ISBN 0-7356-1129-7). The most useful part of this book is Chapter 17 for me. This is good book for someone who needs to know how to optimized your hardware investment and tune your SQL server. It is a good book to have if you don't mind spending $50. Introduction to performance tuning,
September 07, 2004
This book has the title `Technical Reference' and should be regarded as such. The DBA, working in a company which doesn't consider performance-tuning important enough to dedicate a policy to, who is confronted with a sudden structural diminishing of performance and is to find out where this bottleneck stems from will not benefit from this book. For example, the book dedicates a mere two pages on "interpreting Graphical Execution Plans" and gives only 1 example. For a useful checklist on where to look first when confronted with the so-called `query from hell' one should read other books. But for the novice in tuning, the one who is unfamiliar to concepts like locks, RAID, system monitor, I/O,page vs rowlevel, differential backups, how to log in on queryanalyzer, index tuning wizard, etc this book can serve as an introduction. But once past this introduction, this book has served it's purpose.
 Look elsewhere,
May 18, 2004
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?); merely giving me a list of them is redundant. This was the biggest letdown for me - I need this info!
There are other important omissions. I have spent literally weeks identifying and working round failures in the query plan optimiser. This serious issue is not properly addressed except for a chapter introducing query hints. A taxonomy of optimiser failures and ways of tackling each type might save others from the headaches I've had. Optimiser hints do not always suffice.
The book is rated on the back for user levels IT Implementer and Corporate Developer. That is far too generous. Excellent,
December 29, 2003Coverage 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. Great Book. If you read it you will understand why...,
October 23, 2003 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
You might also be interested in these items...
|
|