Best Practices for Building Tier 1 Enterprise Business Intelligence Solutions with…
Performance Tuning and Optimization in Microsoft SQL Server 2008 R2 and SQL Server Code-Named "Denali"
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.
Download
Download this episode
Event Homepage
Tech·Ed North America 2011More episodes in this series
Manual Testing with Microsoft Test Manager 2010
Related episodes
T-SQL Power! SQL Server Windows That Open Doors
SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches
Best Practices with Integrating Common Language Runtime in Microsoft SQL Server
T-SQL Power! The OVER Clause: Your Key to No-Sweat Problem Solving
Auditing, Tracking, and Change Monitoring Technologies in Microsoft SQL Server 2008
Masterclass: A Day in the Life of a Database Transaction
Virtualisation and Consolidation Considerations for Microsoft SQL Server 2008
The Pros and Cons of Stored Procedures
The Most Persistent Microsoft SQL Server Myths (and Why They Are Wrong)
Microsoft SQL Server 2008: Performance Profiling and Troubleshooting with Extended Events
The Discussion
-
AyyappanThangaraj Adam mechanic....Good presentation. I like the way you deal with SQL Server performance problems.
Thanks to Mike Wachal and Adam
-
tormenta Very useful presentation
You are doing a very good job spreading knowledge about how to use SQL Server (Denali).
Thank you