• List Price: $49.99
  • Save: $27.85 (56%)
FREE Shipping on orders over $35.
Only 3 left in stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Professional SQL Server 2... has been added to your Cart
+ $3.99 shipping
Used: Very Good | Details
Sold by hippo_books
Condition: Used: Very Good
Comment: Very Good: Cover and pages show some wear from reading and storage.
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
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

Professional SQL Server 2005 Performance Tuning Paperback – January 29, 2008

9 customer reviews
ISBN-13: 978-0470176399 ISBN-10: 0470176393 Edition: 1st

Buy New
Price: $22.14
12 New from $13.93 23 Used from $0.84
Amazon Price New from Used from
"Please retry"
"Please retry"
$13.93 $0.84

Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$22.14 FREE Shipping on orders over $35. Only 3 left in stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Professional SQL Server 2005 Performance Tuning + Microsoft SQL Server 2005 Unleashed
Price for both: $68.29

Buy the selected items together

Editorial Reviews

From the Back Cover

Professional SQL Server 2005 Performance Tuning

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. In addition, the authors demonstrate how to make use of the key tools for SQL Server Performance tuning.

Broken into four parts, the book first walks you through how to discover bottlenecks when something is wrong and how to monitor SQL Server to see whether there is a resource bottleneck. You'll then learn how to identify and remove the problems that are causing poor performance. The next section explains the preventive measures you can take to try to avoid a performance problem entirely. Finally, you'll learn how to achieve better performance and you'll take a look at some of the challenges involving performance tuning at the later stages of a product's life.

What you will learn from this book

  • How to use the SQL Server wait types to find resource bottlenecks and the queries that are creating them

  • Ways to tune and configure the schema so you can remove bottlenecks

  • Techniques for creating standard workloads for use in performance testing

  • Benefits of storage subsystem performance and robustness

  • How to use SQLIO and SQLIOSim to their full potential

  • Best practices for a successful deployment

Who this book is for
This book is for consultants, developers, DBAs, architects, or anyone with an interest in SQL performance. A working knowledge of T-SQL and knowledge of how to perform basic SQL Server and OS administrative tasks is necessary.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

About the Author

Steven Wort has been working with SQL Server for the past 14 years. He is currently a developer in the Windows group at Microsoft where he works on performance and scalability issues on a large database system. Steven has been at Microsoft for nearly 7 years, working in the Windows group for the past 2 years. Prior to this, Steven spent 2 years in the SQL Server group working on performance and scalability. His first job at Microsoft was 3 years spent working in what is now CSS as an escalation engineer on the SIE team. During this time Steven was able to travel the world working with some of Microsoft’s customers on their performance and scalability problems. Before coming to Microsoft, Steven spent 20 years working in the United Kingdom as a freelance consultant specializing in database application development. When Steven isn’t busy working, he can be found spending time with his family and enjoying many fitness activities in the great outdoors of the Pacific Northwest.

Christian Bolton has been working with SQL Server since 1999 and in 2007 became a director and database architect for Coeo Ltd, a Microsoft Certified Partner focused on large-scale and complex SQL Server projects in the United Kingdom. Prior to this, Christian worked for 5 years as a senior premier field engineer for Microsoft UK, working with some of Microsoft’s biggest customers across EMEA. His specialist areas are high availability, scalability, and performance tuning. Christian works out of London and lives in the south of England with his wife and daughter. He can be contacted at http://coeo.com or through his blog at http://sqlblogcasts.com/blogs/christian.

Justin Langford has worked as a premier field engineer for Microsoft specializing in SQL Server for the past 3 years.Much of this time has been focused on sharing best practices for operations and optimization with some of the United Kingdom’s largest financial and government organizations. Justin previously worked as a consultant foraMicrosoft Partner focusing on upgrade, migration, and software deployment projects for enterprise customers. Outside of work, Justin enjoys yacht racing, snowboarding, and has a keen interest in classic British sports cars.

Michael Cape is a database developer with experience in a variety of industries. Those industries are mortgage banking, pension administration, advertising, logistics, insurance, and labor management. Michael holds a BSCS degree and got his start with database development with SQLBase from Gupta. Michael also has 5 years experience with DB2, and has been working with SQL Server, starting with version 7, for the last 7 years. Outside work, Michael spends time with his wife and two children. He also enjoys golf, bicycling, fishing, and kite flying.

Joshua Jin works for the Intel Corporation. He is a certified SQL Server MCITP database administrator, MCITP database developer, and MCITP business intelligence developer. He specializes in the performance tuning of large-scale and high-volume SQL databases. Prior to working at Intel, he worked on the largest Internet banking implementation in the United States, using SQL server as its database engine. He can be reached at joshua_jin?@yahoo.com.

Douglas Hinson is an independent software and database consultant in the logistics and financial industries, with an extensive SQL Server background. He has co-authored several Wrox books, including Professional SQL Server 2005 Integration Services.

Haidong "Alex" Ji is a professional trainer and consultant specializing in SQL Server administration, performance tuning, high availability, and many other facets of SQL Server. In addition, he also excels at database interoperability issues, having worked extensively with Oracle and MySQL on Unix and Linux. Haidong enjoys learning and sharing his expertise through technical writing, speaking, consulting, training, and mentoring. He co-authored Professional SQL Server 2005 Integration Services (Wrox Press) and Professional SQL Server 2005 Administration (Wrox Press). Haidong maintains a blog at www.haidongji.com/category/technology/.He can be contacted at Haidong.Ji@gmail.com.

Paul Mestemaker is a program manager at Microsoft on the SQL Server product team. During the SQL Server 2005 product cycle, he worked closely with the new dynamic management views on the SQL Server Engine team. Following the launch, Paul moved to the SQL Server Manageability team to create tools on top of the new SQL platform technologies. He was influential in the release of SQL Server 2005 Best Practices Analyzer, Performance Dashboard Reports, and SQL Server 2005 Service Pack 2. He is now a member of the SQLCAT Best Practices team, where he works with subject matter experts across Microsoft and in the community to develop new rules for SQL BPA. Paul has been a speaker at TechEd, PASS, Connections, and other Microsoft conferences. He blogs occasionally; you can check it out here: http://blogs.msdn.com/sqlrem/.

Arindam Sen has worked with SQL Server for the past 8 years and has significant experience with Siebel deployments using SQL Server databases. His interests lie in the area of high availability and performance tuning. He is an MCSE, MCSA, MCAD, and MCDBA. He won the SQL Server innovator award (SQL Server Magazine) in 2003 and 2004. He holds an engineering degree in electronics and an MBA from Duke University.


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 551 pages
  • Publisher: Wrox; 1 edition (January 29, 2008)
  • Language: English
  • ISBN-10: 0470176393
  • ISBN-13: 978-0470176399
  • Product Dimensions: 7.4 x 1.2 x 9.2 inches
  • Shipping Weight: 1.8 pounds (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #1,409,713 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

5 star
4 star
3 star
2 star
1 star
See all 9 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

8 of 8 people found the following review helpful By Jimmy May on July 12, 2008
Format: Paperback
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By James A. Russell on April 11, 2008
Format: Paperback Verified Purchase
I was inheriting a poorly performing 240 Gigabyte database. With just a few chapters, I had the server performing well within the client's specs. The coverage of the features of 2005 are excellent and helps anyone who wants to show that 2005 is competitive with any other enterprise database system.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Sudheer K. Maharana on June 8, 2009
Format: Paperback
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!!)
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By thirstyfortechknowledge on May 13, 2009
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 8 people found the following review helpful By R. Pathak on April 27, 2008
Format: Paperback Verified Purchase
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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Professional SQL Server 2005 Performance Tuning
This item: Professional SQL Server 2005 Performance Tuning
Price: $22.14
Ships from and sold by Amazon.com

What Other Items Do Customers Buy After Viewing This Item?