Main Content

De-mystifying Execution Plan Analysis

About the Talk

April 24th, 2010 6:00 AM

Microsoft's Atlanta offices located at 1125 Sanctuary Pkwy Ste 300, Alpharetta GA

Microsoft's Atlanta offices located at 1125 Sanctuary Pkwy Ste 300, Alpharetta GA

Too often the query plan, or how the SQL Server engine actually implements the logical query, is ignored by developers and DBAs. The reason for not trying to dive into the meaning behind the hyro-glyphic plan is simple: It's not easy to understand what all those icons mean in isolation, never mind as a collection. This session will bridge the gap between the theory of internals, where the details are mentioned but not demonstrated, and the logical query. A series of actual query examples will show how queries are treated by the optimizer and why; what to do to identify slow performing queries, and how to make simple adjustments to allow the query to perform significantly better.

Share URL:

Ratings and Recommendations

Avg. Rating

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

Other Talks at SQL Saturday #41

comments powered by Disqus