Main Content

Best Practices for Working With Execution Plans

A talk by at PASS Summit 2009

About the Talk

November 3, 2009 5:15 AM

Seattle, WA

Seattle, WA

This extended 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. Access through XQuery against the XML will be demonstrated through several practical applications. The overall focus of the session will be towards practical methods that can be applied in the attendees systems immediately.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus