Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
- ISBN: 9781118177655 | 1118177657
- Cover: Paperback
- Copyright: 11/6/2012
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