Professional SQL Server 2005 Performance Tuning

( 2 )

Overview

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...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (13) from $1.99   
  • New (6) from $19.97   
  • Used (7) from $1.99   
Close
Sort by
Page 1 of 1
Showing 1 – 4 of 6
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$23.98
Seller since 2008

Feedback rating:

(4417)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
0470176393 SHIPS WITHIN 24 HOURS!! (SAME BUSINESS DAY) GREAT BOOK!!

Ships from: BAY SHORE, NY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$19.99
Seller since 2008

Feedback rating:

(2232)

Condition: New
0470176393 New Condition. May Contain Light Shopwear To Cover. All Else Is In Great Shape. Ships Immediately.

Ships from: Lindenhurst, NY

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$19.97
Seller since 2005

Feedback rating:

(1603)

Condition: New
2008-01-29 Paperback 1 New 0470176393 New Condition. May Contain Light Shopwear To Cover. All Else Is In Great Shape. Ships Immediately.

Ships from: Lindenhurst, NY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$33.49
Seller since 2005

Feedback rating:

(330)

Condition: New
2008 Softcover New

Ships from: Hillsboro, OR

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing 1 – 4 of 6
Close
Sort by
Sending request ...

Overview

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.
Read More Show Less

Product Details

  • ISBN-13: 9780470176399
  • Publisher: Wiley
  • Publication date: 1/29/2008
  • Series: Programmer to Programmer Series
  • Edition number: 1
  • Pages: 551
  • Product dimensions: 7.20 (w) x 9.00 (h) x 1.40 (d)

Meet 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.

Read More Show Less

Table of Contents

Acknowledgments.

Introduction.

Part I: Finding Bottlenecks when Something’s Wrong.

Chapter 1: Performance Tuning.

Chapter 2: Monitoring Server Resources with System Monitor.

Chapter 3: Monitoring SQL Server Resources with System Monitor.

Chapter 4: SQL ServerWait Types.

Chapter 5: Finding Problem Queries with SQL Profiler.

Part II: Removing Bottlenecks with Tuning.

Chapter 6: Choosing and Configuring Hardware.

Chapter 7: Tuning SQL Server Configuration.

Chapter 8: Tuning the Schema.

Chapter 9: Tuning T-SQL.

Part III: Preventative Measures and Baselining Performance with Tools.

Chapter 10: Capturing, Measuring, and Replaying a Workload Using SQL Profiler.

Chapter 11: Tuning Indexes.

Chapter 12: How Fast and Robust Is Your Storage?

Chapter 13: SQL Server 2005 Performance Dashboard Reports.

Part IV: Roadmap to Server Performance.

Chapter 14: Best Practices for Designing for Performance from the Start.

Chapter 15: Successful Deployment Strategies.

Index.

Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Posted January 7, 2009

    I Also Recommend:

    Pretty Good.

    This is one of the pretty good book that I have read so far on SQL Server.<BR/>Material is well presented . It talks about Wait events ... which I could hardly see in any other SQL Server book .<BR/><BR/>Cons : From my perspective , I like the font settings from Apress publications .

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 12, 2008

    Professional SQL Server 2005 Performance Tuning from Wrox ROCKS!

    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 no customer reviews here. 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

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)