Professional SQL Server 2008 Internals and Troubleshooting

by Christian Bolton and Brent Ozar
Avg. Rating:
Publish Date: January 01, 2010
Read Review ()
View Larger
Tell a Friend

Overview

A hands-on resource for SQL Server 2008 troubleshooting methods and tools

SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.

You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.

Topics Covered:
* SQL Server Architecture
* Understanding Memory
* SQL Server Waits and Extended Events
* Working with Storage
* CPU and Query Processing
* Locking and Latches
* Knowing Tempdb
* Defining Your Approach To Troubleshooting
* Viewing Server Performance with PerfMon and the PAL Tool
* Tracing SQL Server with SQL Trace and Profiler
* Consolidating Data Collection with SQLDiag and the PerfStats Script
* Introducing RML Utilities for Stress Testing and Trace File Analysis
* Bringing It All Together with SQL Nexus
* Using Management Studio Reports and the Performance Dashboard
* Using SQL Server Management Data Warehouse
* Shortcuts to Efficient Data Collection and Quick Analysis |||This book is sold in the US by Sony Electronics Inc. |||This book is sold in Canada by Sony Electronics Inc.

Author Information

Christian Bolton

CHRISTIAN BOLTON is the Technical Director for Coeo Ltd., a leading provider of SQL Server consulting and managed support services in the UK and Europe. Prior to this Christian worked for 5 years at Microsoft, leading the SQL Server Premier Field Engineering team in the UK. He is a Microsoft Certifi ed Architect, Master and MVP for SQL Server, and co-author of Professional SQL Server 2005 Performance Tuning. He works out of London and lives in the south of England with his wife and children. He can be contacted at christian@coeo.com. Christian authored chapters 1, 2, 7, 13 and the online chapter 16 in addition to lending his authoring expertise where needed on other chapters and functioned as the lead author for the entire project.

Justin Langford

No bio available for Justin Langford.

Brent Ozar

No bio available for Brent Ozar.

James Rowland-Jones

No bio available for James Rowland-Jones.

Steven Wort

No bio available for Steven Wort.

Gross Cindy

No bio available for Gross Cindy.

Jonathan Kehayias

No bio available for Jonathan Kehayias.

Customer Reviews

9780470484289

There are no customer reviews available at this time. To add your review, Register or Sign In to your account using our free Reader Library software.