Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting

5.0 1
by Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford
     
 

View All Available Formats & Editions

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

Overview

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.

Product Details

ISBN-13:
9781118177655
Publisher:
Wiley
Publication date:
11/06/2012
Pages:
576
Sales rank:
428,836
Product dimensions:
7.40(w) x 9.20(h) x 1.10(d)

Related Subjects

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Professional SQL Server 2012 Internals and Troubleshooting 5 out of 5 based on 0 ratings. 1 reviews.
Davis_DeBard More than 1 year ago
Good Food for the DBA. 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.