Note: Supplemental materials are not guaranteed with Rental purchases.


You may extend rentals at any time.

Professional SQL Server 2012 Internals and Troubleshooting

ISBN: 9781118177655 | 1118177657
Edition: 1st
Format: Paperback
Publisher: Wrox
Pub. Date: 11/6/2012

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Top 5 reasons to order all your textbooks from Knetbooks:

  • We have the lowest prices on thousands of popular textbooks
  • Free shipping both ways on ALL orders
  • Most orders ship within 48 hours
  • Need your book longer than expected? Extending your rental is simple
  • Our customer support team is always here to help
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

Please wait while this item is added to your cart...