Professional SQL Server 2008 Internals and Troubleshooting
By Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort
Publisher: Wiley / Wrox
Final Release Date: January 2010
Pages: 624

An in-depth look at SQL Server and best practices fortroubleshooting

When faced with a variety of SQL Server issues, you need to beable to troubleshoot SQL Server as well as its underlying operatingsystem. To that end, this author group of SQL Server expertspresents you with invaluable advice that brings together—andsimplifies—practical internal information concerning SQLServer along with troubleshooting techniques and methodologies.Packed with real-world examples of ways to effectively usetroubleshooting tools, this book shows you how to efficiently andaccurately determine the root of your SQL Server problem so you cansuccessfully resolve it.

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

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

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

  • Equips you with the knowledge to confidently specify and monitoryour 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, theManagement Data Warehouse, and how to build your own SQL ServerManagement Studio reports

Wrox guides are crafted to make learning programminglanguages and technologies easier than you think. Written byprogrammers for programmers, they provide a structured, tutorialformat that will guide you through all the techniques involved.

Programmer Forums
Join our Programmer to Programmer forums to ask and answerprogramming questions about this book, join discussions on thehottest topics in the industry, and connect with fellow programmersfrom around the world.

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

Read More
Find articles, ebooks, sample chapters and tables of contents forhundreds of books, and more reference resources on programmingtopics that matter to you.

Product Details
Recommended for You
Customer Reviews
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $59.99
Formats:  ePub, Mobi, PDF