Professional SQL Server 2012 Internals and Troubleshooting

The 2012 release of SQL Server is the most significant one since2005 and introduces an abundance of new features. This criticalbook provides in-depth coverage of best practices fortroubleshooting performance problems based on a solid understandingof both SQL Server and Windows internals and shows experienced DBAshow to ensure reliable performance. The team of authors shows youhow to master the use of specific troubleshooting tools and how tointerpret their output so you can quickly identify and resolve anyperformance issue on any server running SQL Server.

• Covers the core technical topics required to understand how SQLServer and Windows should be working
• Shares best practices so that you know how to proactivelymonitor and avoid problems
• Shows how to use tools to quickly gather, analyze, andeffectively respond to the source of a system-wide performanceissue

Professional SQL Server 2012 Internals andTroubleshooting helps you to quickly become familiar with thechanges of this new release so that you can best handle databaseperformance and troubleshooting.