Average Reviews:
(More customer reviews)Are you looking to buy Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference? Here is the right place to find the great deals. we can offer discounts of up to 90% on Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference. Check out the link below:
>> Click Here to See Compare Prices and Get the Best Offers
Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference ReviewI 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?); 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.Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference Overview
Performance tuning a relational database can be engaging yet frustrating, and this guide gives you the practical information you need to configure and tune a Microsoft® SQL Server™ 2000 database for better, faster, more scalable solutions. The authors start with the basics and build upon them to teach the mechanics of performance tuning and how they affect the whole system. This book also shows how to optimize for the underlying operating system and hardware. It's the only book of its kind coauthored by engineers who have worked in the SQL Server performance group.
Expert instruction helps you understand these topics:
THE BASICS:
Architectural fundamentals that affect tuning
I/O tuning and RAID storage considerations
How to tune hardware, database layout, and configuration parameters
Feature enhancements for better ease-of-use, performance, manageability, and reliability.
SERVER TUNING:
How to use the Microsoft Windows® 2000 System Monitor and the SQL Server Profiler to shorten transaction response times.
SIZING AND CAPACITY PLANNING:
How to model software and hardware usage to predict resource consumption and conduct preconfiguration planning, and how to perform what-if scenarios about workload growth to avoid slow response times.
CONFIGURING AND TUNING:
How to tune online transaction processing (OLTP) systems, data warehouses, and replicated systems.
How to set up your system for high-performance backup and recovery.
TUNING SQL STATEMENTS:
How to get optimal performance by using Query Analyzer and Profiler to tune SQL statements and stored procedures.
How to take advantage of indexes and hints.
Want to learn more information about Microsoft® SQL Server 2000(TM) Performance Tuning Technical Reference?
>> Click Here to See All Customer Reviews & Ratings Now
