Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort
Wrox Programmer to Programmer™
Join the discussion @ p2p.wrox.com
Professional
SQL Server
®
2008
Internals and Troubleshooting
$59.99 USA
$71.99 CAN
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 under-
standing 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
Christian Bolton is coauthor of Professional SQL Server 2005 Performance Tuning
and Technical Director for Coeo Ltd.
Justin Langford is coauthor of Professional SQL Server 2005 Performance Tuning
and leads the Managed Support team for Coeo Ltd.
Brent Ozar is a SQL Server expert for Quest Software.
James Rowland-Jones is an advisory consultant for EMC Consulting.
Steven Wort is a developer in the Windows Division at Microsoft.
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.
Database Management / General
An in-depth look at SQL Server and
best practices for troubleshooting
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.
Bolton, Langford,
et al.
Professional
SQL Server
®
2008
Internals and Troubleshooting
