Performance Tuning and Optimization in Microsoft SQL Server 2008 R2 and SQL Server Code-Named "Denali"

Understanding when to search for performance problems and how to tune your queries to correct them is one of the most persistent questions that face DBAs. Join Adam and Mike to explore a methodology for discovering and improving performance problems. Along the way you'll see examples that take advantage of both dynamic management objects and the powerful Extended Events system,and learn how to fix a few specific--and all too common--problems that we see again and again in customer systems.