• RRP: £50.00
  • You Save: £24.01 (48%)
FREE Delivery in the UK.
Only 3 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Professional SQL Server 2... has been added to your Basket

Dispatch to:
To see addresses, please
Please enter a valid UK postcode.
+ £2.80 UK delivery
Used: Good | Details
Sold by rbmbooks
Condition: Used: Good
Comment: Used, good: average wear, reasonable shape, may have limited notes and/or highlighting. Delivered in 10-12 business days from the USA. Money-back guarantee.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Professional SQL Server 2012 Internals and Troubleshooting Paperback – 30 Oct 2012

4.0 out of 5 stars 1 customer review

See all 3 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
£24.94 £23.13
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more

Man Booker International Prize 2017
A Horse Walks Into a Bar has won the Man Booker International Prize 2017. Learn more
£25.99 FREE Delivery in the UK. Only 3 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Frequently bought together

  • Professional SQL Server 2012 Internals and Troubleshooting
  • +
  • Microsoft SQL Server 2012 Internals
Total price: £71.34
Buy the selected items together

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

  • Paperback: 576 pages
  • Publisher: Wrox; 1 edition (30 Oct. 2012)
  • Language: English
  • ISBN-10: 1118177657
  • ISBN-13: 978-1118177655
  • Product Dimensions: 18.3 x 2.8 x 22.9 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 753,426 in Books (See Top 100 in Books)
  • If you are a seller for this product, would you like to suggest updates through seller support?

  • See Complete Table of Contents

Product description

From the Back Cover

Proven techniques and best practices for troubleshooting SQL Server 2012

This book is packed with expert advice and real–world examples, showing you how to troubleshoot SQL Server 2012 based on a thorough understanding of SQL Server and Windows internals. It shows how to master the use of specific troubleshooting tools, and how to interpret their output to quickly identify and resolve any performance issue?on any server running SQL Server.

Professional SQL Server 2012 Internals and Troubleshooting:

  • Takes you through the life cycle of a query to help present SQL Server′s architecture in a practical context
  • Helps to demystify server hardware and storage systems and examines how SQL Server uses memory and how you should configure it
  • Explores query processing and execution, locking, and how tempdb works
  • Shows how to use troubleshooting tools to gather, analyze, and respond to the source of a system–wide performance issue
  • Details how to enhance your troubleshooting toolset with Powershell and Extended Events, and how to manage SQL Server in a virtual environment


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. and a Microsoft Certified Architect, Master, and MVP for SQL Server.

Justin Langford is a Director at Coeo Ltd., a SQL Server MVP, and an author.

Glenn Berry is a Principal Consultant at SQLSkills.com, a SQL Server MVP, and an author.

Gavin Payne is a Senior Consultant for Coeo Ltd. and a Microsoft Certified Master for SQL Server.

Amit Banerjee is a Premier Field Engineer at Microsoft and the owner of TroubleshootingSQL.com.

Rob Farley is Owner/Principal of LobsterPot Solutions, a PASS Director, and a SQL Server MVP.

What other items do customers buy after viewing this item?

Customer Reviews

4.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback

I have written a chapter-by-chapter review of this book on [...]. the first part of this review follows:

I expected this book to give me an insight into what to do when I get various SQL Server problems. Identify the problem? How do I solve it? And can it give me an understanding as to why it occurred? Did the book fulfil these requirements?

There are two distinct parts to this book, internals and troubleshooting. The first section is more theoretical, and the second is more practical. The aim of the internals section is to provide a deeper background understanding for the subsequent troubleshooting section.

The topics covered are both diverse in terms of subject matter (e.g. hardware, concurrency, extended events) and in terms of the expected level of experience (e.g. PowerShell is introductory, and latches are advanced). Some of the subjects seem a bit off topic (Virtualization), and even esoteric (Spinlocks).

More infor here: [...]
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta) (May include reviews from Early Reviewer Rewards Program)

Amazon.com: 4.6 out of 5 stars 8 reviews
3.0 out of 5 stars Good book 13 Oct. 2013
By Cristian Diaz - Published on Amazon.com
Format: Kindle Edition Verified Purchase
This is a good overview of the performance troubleshooting aspects of SQL Server. However I expected a little bit more detail on each topic more like an internals from Delaney.
I think this is a great book for people initiating on performance troubleshooting ( DBA Jr and/ or semi Sr).
If you are a highly experienced DBA looking for in depth detail, then wait for the upcoming SQL 2012 Internals from Kalen Delaney.
1 of 1 people found the following review helpful
5.0 out of 5 stars Very detailed 1 April 2013
By chrishuffman5 - Published on Amazon.com
Format: Paperback Verified Purchase
Great book for the experienced DBA thats looking to understand how the core of SQL server works. Lots of handy scripts included as well.
5.0 out of 5 stars Excellent Reference 17 Dec. 2013
By Amazon Customer - Published on Amazon.com
Format: Kindle Edition Verified Purchase
If you are a database professional than you want this book. Period! Buy it now! You will not be disappointed.
2 of 3 people found the following review helpful
5.0 out of 5 stars In Continuity 27 Nov. 2012
By Eric_Nimo - Published on Amazon.com
Format: Paperback Verified Purchase
I was an avid reader of "Professional SQL Server 2008 Internals and Troubleshooting". It's always an actual great book.
With "Professional SQL Server 2012 Internals and Troubleshooting" you'll go to the next step in the same great way.
All SQL Server DBA will find something to satisfy them. And much more!
Both theoretical and practical, it leads you into the depths with profit.
I really enjoy. Hope you too :))
4 of 4 people found the following review helpful
5.0 out of 5 stars Perfect book for Internals & Troubleshooting SQL Server 19 April 2013
By Neeraj Agrawal - Published on Amazon.com
Format: Paperback
I instantly liked the book. The first part of the book takes the reader into the internals of SQL Server. Chapter 1 explains, briefly, the architecture of SQL Server and uses a SELECT query to show how all the internal components come together to execute & return the results back to the user. Next few chapters talk about h/w components, memory, & storage systems. The chapter on tempdb is particularly interesting as it shows the way to optimizing tempdb performance and warns us about the pitfalls of leaving the tempdb unattended. Locking & Latches have always been subjects left alone by most DBAs. This book present them in such a way that it becomes easy to understand and be friends with them again. The chapter also covers the basics of isolations levels, locks etc.
Part two of the book dives into the diagnostics and troubleshooting arena. First off, the book deals with the correct approach/best practices of troubleshooting and analysis. There are a plethora of diagnostics tools available today and sometimes the DBA is clueless about the quality of these tools. The book meticulously covers some of such solid tools like Performance Monitor, PAL, SQLDIAG, SQL Nexus, Powershell etc. There is one chapter dedicated to each of these tools. Extended events have come to the forefront with SQL Server 2012. There is now an inbuilt graphical interface that can be used. The best part is that they have a very low impact on the overall performance. Extended events are covered thoroughly in the book. The last chapter deals with SQL Server virtualization and how to use it within the enterprise.
Overall, I will give two thumbs up to the book. This can easily become a reference guide for any DBA during his day-to-day job responsibility. I will definitely recommend the book to my fellow DBAs.
Were these reviews helpful? Let us know