SQL Server 2008 Internals & Troubleshooting

You need more than just SQL Server engine knowledge – you need to know how CPU, memory, and storage affect your database server.  This book goes beyond typical internals books and gives you useful information that will help you troubleshoot SQL Server problems every day.  We give you invaluable advice that brings together—and simplifies—practical internal information concerning SQL Server along with troubleshooting techniques and methodologies.

Our book, Professional SQL Server 2008 Internals & Troubleshooting, is packed with real-world examples of ways to effectively use troubleshooting tools and tips like:

Professional SQL Server 2008 Internals and Troubleshooting Book

Professional SQL Server 2008 Internals and Troubleshooting Book

  • The lifecycle of a query to establish an understanding of the fundamental concepts and architectures
  • Memory including physical components, Windows memory management, and SQL Server’s own memory architecture
  • SQL Server wait types and how to monitor them with Extended Events
  • Knowledge to confidently specify and monitor your storage performance requirements
  • SQL Server’s locking model, the internal use of latches, and row versioning

When you’re convinced that it’s the right resource for you, you can order the book today.

6 thoughts on “SQL Server 2008 Internals & Troubleshooting

  1. Pingback: soumyarintu

  2. Just received your book from Amazon…goose bumps from just reading the intro…ashame I have to do other things besides just reading this book :(

  3. I’ve got the book but I can’t find how to download chapter 16! Any ideas please? I’ve been on wrox.com and registered with P2P but still can’t seem to find it anywhere. I’m told it’s a good chapter so would really like to get it.

    It’s a great book too, haven’t had the time to read cover to cover yet but it’s helped with a lot of stuff already.

    Great work!

  4. Wow, that is a really good question – I could have sworn it used to be on the book’s home page at Wiley.com, but I’m not seeing it there either. I’ll email Christian and ask.

  5. Brent

    Wonder if you got anywhere with finding out how to download Chapter 16 of the book?

    Regards
    Bryn

  6. Yes, just go to the Wiley site for our book and it’s listed in the download page. Thanks!