|
Professional SQL Server 2005 Performance Tuning (Programmer to Programmer) |  | Authors: Steven Wort, Christian Bolton, Justin Langford, Michael Cape, Joshua J. Jin, Douglas Hinson, Haidong Ji, Paul A. Mestemaker, Arindam Sen
Publisher: Wrox
Category: Book
List Price: $49.99
Buy New: $19.19
as of 9/10/2010 16:36 CDT details
You Save: $30.80 (62%)
New (34) Used (18) from $17.98
Seller: bookcloseouts_us
Rating:  8 reviews
Sales Rank: 396664
Media: Paperback
Pages: 551
Number Of Items: 1
Shipping Weight (lbs): 1.9
Dimensions (in): 9.1 x 7.4 x 1.4
ISBN: 0470176393
Dewey Decimal Number: 005.7585
EAN: 9780470176399
ASIN: 0470176393
Publication Date: January 29, 2008
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you’ll then learn how to identify and remove the problems that are causing poor performance. You’ll discover preventive measures you can take to try to avoid a performance problem entirely and you’ll learn how to achieve better performance.
|
| Customer Reviews:
Showing reviews 1-5 of 8
 Professional SQL Server 2005 Performance Tuning from Wrox ROCKS! July 12, 2008
Jimmy May (Indianapolis, IN)
8 out of 8 found this review helpful
I have long been impressed with Steven Wort as a result of his work at Microsoft & his promiscuous, insightful posts on various SQL Server sites. When I learned he was the lead author of "Professional SQL Server 2005 Performance Tuning" I could scarcely wait for its publication.
Now that it's been out for a bit I'm shocked to see only two reviews here on Amazon. This book is a worthy read & well worth a five-star rating.
I am extremely impressed at the utility of this book. Information related to SQL Server performance is fairly ubiquitous, yet this work is unique in its approach. I know of no other reference ever written for SQL Server which amalgamates such great information integrated from the perspective of hardware, fundamental schema design, & tools.
For example, Steven introduces a tool which cleverly leverages the SQLIO.exe tool as well as explains how to use it. I've never seen anything quite like it. It's so useful I use it at almost all of my customer sites.
In fact, I recommend this book to all my customers & colleagues.
If the book has a deficit, it's a mixed one. Though it cites the importance of disk partition alignment, an arcane yet critical component of disk configuration, the text unfortunately fails to provide the information required to implement it.
No book can be a one-stop reference for a concept as broad as SQL Server performance, yet Professional SQL Server 2005 Performance Tuning comes as close as any I've seen.
--Jimmy May, Aspiring Geek
Comprehensive, Practical and Informative!!!! June 8, 2009
Sudheer K. Maharana
3 out of 3 found this review helpful
From my experience with SQL Server and Oracle for the last 15 years of my IT experience, Database Performance tuning is more of an art and science (even though the book says it is more of a science). As SQL Server transformed into different versions, the information to gather performance related data matrix improved. Hence, the quest for ways to get information on how to troubleshoot performance problems in SQL Server grew.
I have referred many books on SQL Server Performance Tuning, but most of the books I have referred provided generic information and go on describing mundane performance tuning methods such as SQL Profiler, Execution Plan and Performance Logs without any examples to refer or try with. I did not find many books that deal with performance tuning concepts from ground up. This book defines the performance tuning concepts from ground up and also describes the "how and what" data point to gather, measure and analyze to troubleshoot the performance problems.
Book starts with good introduction to the basic concepts of Performance Tuning in a methodical approach. It defines how to understand a problem statement, how to go about solving those problems and how to prevent it from occurring. The book goes about all facets of performance tuning such as Server and database tuning, SQL tuning, creating a workload for creating a performance benchmark, system tuning for memory, processor and storage.
I liked the chapters dealing with SQL Server Wait types, Tuning Indexes, Tuning Schema and Capturing, Measuring and Replying workloads.
Like any other book, it has some shortcomings too. For instance there are some typos and which can easily be caught if you understand the subject in the chapter.
So I will suggest if you are an experience DBA or a DBA who wants to get into Performance Tuning (a good line to be in!!), please add this book to your cart!!!!(no.. I was not paid to write this!!)
Good & Practical Advice May 14, 2009
thirstyfortechknowledge (Wilmington, MA)
2 out of 2 found this review helpful
This book presents the reader with a good overview of features, including their trade-offs. It's a good read if you're looking for practical advice on how to implement/configure vs. what's possible to implement/configure. Additionally, it doesn't simply present separate topics in isolation, but connects them so that the reader has a clear understanding regarding how different features and implementation choices interact.
A great book and still very relevant November 11, 2009
Tom Mills (Atlanta, GA USA)
1 out of 1 found this review helpful
Although this book appears to be specific to SQL Server 2005, it's not. The techniques and tools are still extremely relevant to current and future versions of SQL Server. Whether you are a database administrator who handles performance issues on a daily basis or a developer building a database application, this book should be on your desk. The authors have a deep understanding of how to make your database server an efficient, stable system. Their ability to explain complex issues and provide relevant solutions makes this a must-have book.
Excellent April 27, 2008
R. Pathak
5 out of 7 found this review helpful
I have been trying to read something that could give me a kick start in performance monitoring and tuning. And, I must say this book has been a great help. I have read many other books but but this book has been - by far- much easier to comprehend and implement. Hats-off to all writters and editors.
Showing reviews 1-5 of 8
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com | |
