Play Performance Tuning and Optimization in Microsoft SQL Server 2008 R2 and SQL Server Code-Named "Denali"
Download this episode
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.
Available formats for this video:
Actual format may change based on video formats available and browser capability.