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

Sign in to queue

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

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents