9781118177655

Professional SQL Server 2012 Internals and Troubleshooting

  • ISBN 13:

    9781118177655

  • ISBN 10:

    1118177657

  • Edition: 1st
  • Format: Paperback
  • Copyright: 11/06/2012
  • Publisher: Wrox

Note: Not guaranteed to come with supplemental materials (access cards, study guides, lab manuals, CDs, etc.)

Extend Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Rental Options

List Price $59.99 Save

Free Shipping Free Shipping On Every Order
Usually Ships in 3-4 Business Days

Summary

The book shows how to approach troubleshooting SQL Server 2011 from a thorough understanding of both the SQL Server database architecture and internals as well as Windows OS internals. It shows how to master the use of specific troubleshooting tools, and how to interpret their output to quickly identify and resolve any performance issue on any server running SQL Server. Part 1 covers the core technical topics required to understand how SQL Server and Windows should be working. Best practices are discussed so you know how to pro-actively monitor and avoid problems. Part 2 deals with the "tools of the trade" detailing all the tools that professionals use to very quickly gather, analyze and pin down the source of a system wide performance issue. Equally important, the authors focus on best practices for using these tools. Overall, the 2011 edition will be about 75% new. Part 1 - Internals Chapter 1 - SQL Server Architecture Chapter 2 - Demystifying Hardware NEW Chapter 3 - Understanding Memory Chapter 4 - Query Processing and Execution Chapter 5 - Locking and Concurrency Chapter 6 - Latches In-Depth NEW Chapter 7 - Knowing Tempdb Chapter 8 - Inside Storage Structures NEW Chapter 9 - Event Tracing and Extended Events NEW Part 2 - Troubleshooting Tools and Best Practices Chapter 10 - Troubleshooting patterns and practices NEW Chapter 11 - Enhancing your troubleshooting toolset with Powershell NEW Chapter 12 - Rolling your own healthcheck using Dynamic Management Views NEW Chapter 13 - Advanced tracing and analysis with XEvents Profiler NEW Chapter 14 - Delivering Manageability and Performance NEW Chapter 15 - Running SQL Server in a virtual environment NEW Chapter 16 - Using high-end storage platforms effectively NEW Chapter 17 - Shortcuts to efficient data collection and quick analysis NEW ONLINE CHAPTER

Author Biography

Read more

Table of Contents

Read more

Write a Review