Professional SQL Server 2008 Internals and Troubleshooting

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 pres 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.
Shows how to develop a methodology for troubleshooting based on a thorough understanding of SQL Server 2008 and Windows OS internals
Covers mastering specific troubleshooting tools and interpreting their output so that you can quickly identify and resolve any performance issue
Details all the free and proprietary tools that allow you to analyze and determine the source of a system-wide performance problem
Examines how it is critical for both SQL Server and Windows technologies to run smoothly in order to ensure effective SQL Server performance

This practical guide will help you pro-actively monitor and avoid SQL Server problems.



Summary: Great book for *anyone* working with SQL Server
Rating: 5

I recommend this book to everyone. I tell people it just came out, and they look curious because mine's getting worn. The info is clear and concise, and doesn't ramble, so I like it.

A funny example happened running a small VM with SQL Server. It was hanging infrequently and crashing because of RAM memory issues and disk swaps. I had imported the OS into VMware workstation on my laptop, but it had PAE enabled. Disabling PAE, going from 8 to 4KB pages, saved the VM 200MB total RAM utilization. After checking/setting other SQL Server memory settings, and monitoring counters, the system is stable. The memory chapter helped me do all the right things.

I also purchased the .pdf version of the book to search for terms. Its another plus on the laptop. Thanks for a great book!


Summary: Great book that delivers…
Rating: 5

I received the book last week and have been reading it daily. Lots of great information pred in a clear and concise format. This is definitely a book for all levels of SQL DBA's to keep on the desk.


Summary: The Wait is OVER!!!
Rating: 5

I have waited for this book for almost 59 years!!! Thank God it is finally published. Do not put off reading this book. It can change your life! C. Hines