Professional SQL Server 2008 Internals and Troubleshooting

by Christian Bolton, Justin Langford, Brent Ozar

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 CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Genres: Programming

624 pages, Paperback

First published December 29, 2009

Reviews

[Dan · Rating 3 out of 5]

Some good chapters on storage and transactions. The diagnostic tools like SQL Nexus were over my head though