WMV files are unsupported

Click here to open the file

SQLBits 2009

Understanding Graphical Execution Plans

Graphical Execution Plans in SSMS is not only the best way to know what is happenning under the hood of SQL engine but also it is the most accessible one.
There are many times when a developer realises that this snippet is not performing the way it was expected to . This happens as early as dev or unit testing cycle . This is the best time to get hold of those performance bottlenecks by using the most accessible performance tuning option "The Graphical Execution Plan".
It is a one click operation to get to the plan but the terms like Seek, scan , Book mark Lookup , RID lookup and many more soon start puzzling the developer.

This session is aimed at making the developer aware of those terms and using this knowledge decipher the plan.