Professional SQL Server 2012 Internals and Troubleshooting Internals and troubleshooting

Hands-on troubleshooting methods on the most recent release of SQL Server

The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server.
* Covers the core technical topics required to understand how SQL Server and Windows should be working
* Shares best practices so that you know how to proactively monitor and avoid problems
* Shows how to use tools to quickly gather, analyze, and effectively respond to the source of a system-wide performance issue

Professional SQL Server 2012 Internals and Troubleshooting helps you to quickly become familiar with the changes of this new release so that you can best handle database performance and troubleshooting.

The book shows how to approach troubleshooting SQL Server 2012 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 2012 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

Hands-on troubleshooting methods on the most recent release of SQL Server The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server. Covers the core technical topics required to understand how SQL Server and Windows should be working Shares best practices so that you know how to proactively monitor and avoid problems Shows how to use tools to quickly gather, analyze, and effectively respond to the source of a system-wide performance issue Professional SQL Server 2012 Internals and Troubleshooting helps you to quickly become familiar with the changes of this new release so that you can best handle database performance and troubleshooting.