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

Download this episode

Download Video

Description

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.
For more information, check out this course on Microsoft Virtual Academy:

Day:

2

Level:

400 - Expert

Code:

DBI402

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.