Professional SQL Server 2008 Internals and Troubleshooting and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $59.99
  • Save: $17.49 (29%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Condition: Used: Good
Comment: This book is in great condition, and appears to have been gently read. Pages are unmarked and clean. Cover is clean, except has a few light indentation lines, and shows slight age and use. Bottom edge is shelfworn. In short, this is an especially nice copy.
Access codes and supplements are not guaranteed with used items.
Sell yours for a Gift Card
We'll buy it for $2.00
Learn More
Trade in now
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 all 2 images

Professional SQL Server 2008 Internals and Troubleshooting Paperback – January 7, 2010

ISBN-13: 978-0470484289 ISBN-10: 0470484284 Edition: 1st

Buy New
Price: $42.50
30 New from $24.98 25 Used from $12.79
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$42.50
$24.98 $12.79

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Frequently Bought Together

Professional SQL Server 2008 Internals and Troubleshooting + SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) + Microsoft SQL Server 2008 Internals (Developer Reference)
Price for all three: $121.96

Some of these items ship sooner than the others.

Buy the selected items together
NO_CONTENT_IN_FEATURE

Hero Quick Promo
12 Days of Kindle Book Deals
Load your library with Amazon's editors' picks, $2.99 or less each today only. Learn more

Product Details

  • Paperback: 624 pages
  • Publisher: Wrox; 1 edition (January 7, 2010)
  • Language: English
  • ISBN-10: 0470484284
  • ISBN-13: 978-0470484289
  • Product Dimensions: 7.4 x 1.2 x 9.3 inches
  • Shipping Weight: 2.3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.9 out of 5 stars  See all reviews (21 customer reviews)
  • Amazon Best Sellers Rank: #1,020,117 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

An in-depth look at SQL Server and best practices for troubleshooting

When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together—and simplifies—practical internal information concerning SQL Server along with troubleshooting techniques and methodologies. Packed with real-world examples of ways to effectively use troubleshooting tools, this book shows you how to efficiently and accurately determine the root of your SQL Server problem so you can successfully resolve it.

  • Escorts you through the lifecycle of a query to establish an understanding of the fundamental concepts and architectures

  • Examines the use of memory including the physical components, Windows memory management, and SQL Server's own memory architecture

  • Reviews SQL Server wait types and how to monitor them with Extended Events

  • Equips you with the knowledge to confidently specify and monitor your storage performance requirements

  • Details SQL Server's locking model, the internal use of latches, and row versioning

  • Shows you how to use SQLDiag, RML Utilities, SQL Nexus, the Management Data Warehouse, and how to build your own SQL Server Management Studio reports

Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

wrox.com

Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

About the Author

CHRISTIAN BOLTON is the Technical Director for Coeo Ltd., a leading provider of SQL Server consulting and managed support services in the UK and Europe. Prior to this Christian worked for 5 years at Microsoft, leading the SQL Server Premier Field Engineering team in the UK. He is a Microsoft Certifi ed Architect, Master and MVP for SQL Server, and co-author of Professional SQL Server 2005 Performance Tuning. He works out of London and lives in the south of England with his wife and children. He can be contacted at christian@coeo.com. Christian authored chapters 1, 2, 7, 13 and the online chapter 16 in addition to lending his authoring expertise where needed on other chapters and functioned as the lead author for the entire project.

JUSTIN LANGFORD leads the Managed Support team for Coeo Ltd, delivering outsourced 24x7 operations for mission-critical SQL Server platforms. Before joining Coeo, Justin worked for Microsoft in the Premier Field Engineering team and has worked with some of Microsoft’s largest fi nance and government customers in Europe. Justin co-authored Wrox Professional SQL Server 2005 Performance Tuning and lives in London with his girlfriend, Claire. Outside work he enjoys sailing and has a keen interest in classic British sports cars. Justin can be contacted at justinl@coeo.com. Justin authored chapters 9, 11, 12, and 15.

BRENT OZAR is a SQL Server Expert for Quest Software. He has over a decade of broad IT experience, performing SQL Server database administration, systems administration, SAN administration, virtualization administration, and project management. In his current role, Brent trains DBAs on performance tuning, disaster recovery, and virtualization. He has spoken around the globe at events for PASS, SQLBits, SSWUG, and other organizations. Brent founded the Virtualization Virtual Chapter for the Professional Association for SQL Server (PASS), and serves as the Editor-in-Chief at SQLServerPedia.com. Brent blogs at www.BrentOzar.com and discusses diverse topics at http://twitter.com/BrentO. When he’s not talking SQL Server, he enjoys traveling, working with social media, snorkeling, and sampling new restaurants. He is the author of chapters 4 and 14.

JAMES ROWLAND-JONES works for EMC Consulting EMEA as an Advisory Consultant. His principle focus is the delivery of large, scalable, data warehousing, and business intelligence projects. Within this fi eld James specializes in data integration, database architecture, and performance tuning. He is very active in the technical community and is one of the organizers for SQLBits, Europe’s largest SQL Server community conference. James has received the Microsoft MVP award for 2009 and 2010. You can fi nd him online at http://consultingblogs.emc.com/jamesrowlandjones, twitter (@jrowlandjones), linkedin http://www.linkedin.com/in/jrowlandjones, or even using an old fashioned email, james.rowland-jones@emc.com. James authored chapters 6 and 10.

JONATHAN KEHAYIAS is a SQL Server MVP, MCITP Database Administrator and Developer, who got started in SQL Server in 2004 as a database developer and report writer in the natural gas industry. After spending two and a half years working in T-SQL, in late 2006, he transitioned to the role of Database Administrator. He has experience in upgrading and consolidating SQL environments, and has experience in running SQL Server in Virtual Environments on VMWare ESX 3.5+. He is a member of the Tampa SQL Server User Group and a regular speaker about SQL Server at events. Jonathan authored chapter 3.

CINDY GROSS started her SQL Server life as a DBA with a hospital and health plan company in 1993, and moved to Microsoft in 2000 where she has worked ever since. Her roles at Microsoft have included PSS Product Support Engineer, SQL Content Lead, Yukon Readiness Lead, and most recently Dedicated Support Engineer (DSE), all for SQL Server. Cindy enjoys delivering training throughout the United States as well as in Europe and India, including presentations at SQL PASS. In 2008 she started the Boise SQL Server User Group, an affi liate of the SQLCommunity.org site (where she is a worldwide SQL Server Community Leader) to share SQL Server wisdom in the Idaho SQL Server community. Most recently she obtained the Microsoft Certifi ed Master: SQL Server Qualifi cation, which was a hard-fought prize. Over the years Cindy has learned from many wonderful friends and colleagues and they all deserve a word of thanks for contributing to her success. Cindy authored chapter 8.

STEVEN WORT has been working with SQL Server since the early days of SQL Server way back in 1992-93. He is currently a developer in the Windows Division at Microsoft, where he works on performance and scalability issues on large database systems for the Windows Telemetry team. Steven has been at Microsoft since 2000. Prior to working in the Windows Division, Steven spent 2 years working in the SQL Server group, working on performance and scalability. Steven’s fi rst 3 years at Microsoft were spent working in support 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 issues. 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 fi tness activities in the outdoors of the Pacifi c Northwest. Steven authored chapter 5.


More About the Authors

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

Customer Reviews

4.9 out of 5 stars
5 star
19
4 star
2
3 star
0
2 star
0
1 star
0
See all 21 customer reviews
I read both Inside SQL Server and this book.
Krishna Golla
In fact, I can really see that how I can use these concepts in my real life scenarios and help my servers to run better and efficiently.
Pinalkumar Dave
Lots of great information provided in a clear and concise format.
J. Cornell

Most Helpful Customer Reviews

14 of 17 people found the following review helpful By Pinalkumar Dave on March 9, 2010
Format: Paperback
Brief Review: Having a book on internal and associating that with real life is "almost" an impossible task. The reason for using the word "almost" is because this book has accomplished this very well. This internals book is written by keeping real life scenarios as top focus. The highlight of the book is that it teaches how to use internals to troubleshoot the real life issues of performance, storage, query processing and all the other important aspects of SQL Server - A must-have book for everybody who is a hands-on DBA/Developer.

Detail Review: I planned to finish reading this book within a week. Very soon, I realized that I was going over very interesting subjects of SQL Server very quickly and understanding them very well. In fact, I finished reading this book in less than a week, and I have to accept that it offers an interesting journey for its readers. This book is also quite easy to read. This book has addressed some of the complex subjects in such a simple manner that any SQL user can understand it very easily.

The three very important components for any server are CPU, Memory and IO. This book effectively elucidates these three components. The topics usually begin by covering internals which shift to practical implementations after proper amount of internals. In other way, I can say that this book is NOT a usual boring book, which can put you to sleep. Each chapter keeps you interested till the end of it. CPU and IO, which are very important deciding factors for Query cost, are very well explained in the book. This book explains how any query can be understood in terms of internals. After explaining the query internals in terms of CPU and IO, it also explains how the physical memory affects query execution and what are the techniques to improve performance?
Read more ›
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 Nicholas J. Weber on July 9, 2010
Format: Paperback Verified Purchase
I recently finished reading "Professional SQL Server 2008 Internals and Troubleshooting" and wanted to write a quick review about it. As a Production SQL DBA who is required to works with a variety of technologies like SANs, networking etc... I found this book to be a wonderful resource. All too often with SQL books the content seems to be geared towards development DBAs and the in-depth discussion of Storage seems to be some sort of black arts to a lot of DBA's. This book seems to fill in the gap in the market where a lot of SQL books fall short for the "Production DBA". I'm glad to see a book that touched on such a wide array of performance topics including disk sub-systems.

@Toshana
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
1 of 1 people found the following review helpful By Krishna Golla on September 21, 2010
Format: Paperback Verified Purchase
It is a wonderful book to learn about SQL internals and inner workings. I read both Inside SQL Server and this book. Both of them are awesome. I had minor difficulty in understanding few concepts in Inside SQL Server. But this one is really cool with good pictures and queries which will assist a lot during reading and also at work. DBA's dont miss it.
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
1 of 1 people found the following review helpful By Jonathan Fite on April 23, 2013
Format: Paperback Verified Purchase
I got this book because I wanted something that would tell me what SQL Server was doing behind the scenes. The information is laid out clearly and goes into incredible detail about SQL Server and how it uses memory, cpu and storage.
1 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
1 of 1 people found the following review helpful By R. Pathak on January 25, 2011
Format: Paperback Verified Purchase
I read this book about couple to times to understand all the concepts. Very-very nice book with many new concepts consolidated at one place. Also, remember to read chapter 16 that is on the web.
3 Comments 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
1 of 1 people found the following review helpful By John W. Walker on September 27, 2010
Format: Paperback Verified Purchase
Brent Ozar is great at what he does and he suggested this volume to me. It is excellent reading, but is imperative as a reference.
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
Format: Kindle Edition Verified Purchase
This book has a lot of detailed, practical information that is not easily obtained elsewhere. The writing style is clear and readable. A stand-out book in the category.
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
Format: Kindle Edition Verified Purchase
If you are a DBA, or a developer that really wants to know how the database architecture works then this is the books for you. As a professional DBA I recommend this book for anyone who uses MSSQL in there enterprise to process and store critical data, the detailed knowledge of the full MSSQL stack is very valuable when working on performance tuning and overall MSSQL operations.
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

Most Recent Customer Reviews