Start reading Professional SQL Server 2012 Internals and Troubleshooting on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting [Kindle Edition]

Christian Bolton , Justin Langford , Glenn Berry , Gavin Payne , Amit Banerjee , Rob Farley
4.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £39.99
Kindle Price: £37.99 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £2.00 (5%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £37.99  
Paperback £39.99  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Product Description

Product Description

Hands-on troubleshooting methods on the most recent release of SQL Server

The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server.

  • Covers the core technical topics required to understand how SQL Server and Windows should be working
  • Shares best practices so that you know how to proactively monitor and avoid problems
  • Shows how to use tools to quickly gather, analyze, and effectively respond to the source of a system-wide performance issue

    Professional SQL Server 2012 Internals and Troubleshooting helps you to quickly become familiar with the changes of this new release so that you can best handle database performance and troubleshooting.

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

    Product details

    • Format: Kindle Edition
    • File Size: 8429 KB
    • Print Length: 576 pages
    • Publisher: Wrox; 1 edition (18 Oct 2012)
    • Sold by: Amazon Media EU S.à r.l.
    • Language: English
    • ASIN: B009UCNMVS
    • Text-to-Speech: Enabled
    • X-Ray:
    • Word Wise: Not Enabled
    • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
    • Amazon Bestsellers Rank: #412,509 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
    •  Would you like to give feedback on images?

    More About the Authors

    Discover books, learn about writers, and more.

    Customer Reviews

    5 star
    3 star
    2 star
    1 star
    4.0 out of 5 stars
    4.0 out of 5 stars
    Most Helpful Customer Reviews
    2 of 3 people found the following review helpful

    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 | 
    Was this review helpful to you?
    Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars  8 reviews
    3 of 3 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
    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.
    2 of 2 people found the following review helpful
    5.0 out of 5 stars Good Food for the DBA 21 Jan 2013
    By Davis M. DeBard - Published on
    If you're an experienced database administrator, wanting to bone up on what makes SQL Server 2012 tick, this book is for you. Though the title makes it clear the coverage is only SQL Server 2012, the authors cover concepts on SQL Server generally, showing how it has changed through the versions, and where it is headed. The SQLOS, for example, introduced in 2005, has SQL Server taking over some Windows operating system functions critical for performance, while leaving others. You get the history, trend, and 2012 version specifics of each key component of the massive SQL Server architecture. This book is what you need to really understand current technology in SQL Server administration and troubleshooting.
    1 of 1 people found the following review helpful
    5.0 out of 5 stars SQL Administrator, a must read book 26 Aug 2013
    By Amazon Customer - Published on
    This book is a needed reading material to bridge the gap for the Beginner and Advance Book. This is basically an Intermediate book that is clearly written. For me I needed to read the book from beginning to end and using the past chapters as reference. If you are a professional for SQL Server you need to know this material by heart and this is the book for you. This book really helps me to understand the details that are needed to quickly make good decisions when problem arises. Thank you for the authors in creating this book.
    1 of 1 people found the following review helpful
    5.0 out of 5 stars Very detailed 1 April 2013
    By Huff85 - Published on
    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.
    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
    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 :))
    Were these reviews helpful?   Let us know
    Search Customer Reviews
    Only search this product's reviews

    Customer Discussions

    This product's forum
    Discussion Replies Latest Post
    No discussions yet

    Ask questions, Share opinions, Gain insight
    Start a new discussion
    First post:
    Prompts for sign-in

    Search Customer Discussions
    Search all Amazon discussions

    Look for similar items by category