Main Content

Best Practices for Working With Execution Plans

A talk by at SQL Saturday #34

About the Talk

January 30, 2010 4:00 AM

Waltham, MA

Waltham, MA

This session will focus on how best to use and access execution plans. The use of execution plans will focus on identifying and fixing common performance and execution problems within TSQL. The methods defined for using execution plans will follow a problem/solution paradigm in order to show practical ways that execution plans can help solve common problems. Access of execution plans is normally only defined as being from the Management Studio GUI. This session will show methods of access that include direct queries into the procedure cache using dynamic management views and functions and plans captured through the use of trace events defined in Profiler.

Ratings and Recommendations

Avg. Rating

Average based
on 3 ratings

comments powered by Disqus