Understanding Graphical Execution Plans

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.

Ashwani Roy

Ashwani Roy is SQL Server MVP and Senior Consultant with Information Management Group (IMGROUP), winners of the Microsoft Global Business Intelligence Partner of the Year award for the past four years. Ashwani has worked with SQL Server BI stack since 2003 and is Microsoft Certified IT Professional. His main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.

Ashwani Roy's blog http://ashwaniroy.spaces.live.com

---

Downloads

File Type Ext ContentName Presentation .pptx Slide Deck

<< 1 >>

---

Other sessions from this conference

AddIns for SSMS - build your own

Comparing Azure storage and SQL Data Services

Data Mining and SSIS - makes sense.

Data Warehouse Data Modelling

Data Warehousing features in SQL 2008

Database Maintenance Optimization

Designing Effective Aggregations in Analysis Services 2008

Effective test-driven database development

End to End Report Creation and Management in SQL Server Reporting Services 2008

High Availability in SQL Server 2008

Implementing Clustering using SQL Server

Instrumenting, Monitoring and Auditing of SSIS ETL Solutions

Making the SQL developer one of the family with Visual Studio Team System

Message in a bottle: Service Broker from 1 to 100 in 75 minutes!

NHibernate – Open Source Object Relational Mapping (ORM)

Performance Optimization with SQL Server 2008

Performance Tuning your TSQL

Securing and Hardening a SQL Server Implementation - Notes from the Field

SQL Server Architecture: The life of a query

SQL Server’s storage engine

SSIS by example

SSIS Nuggets Live

Stop throwing hardware at the problem !

Understanding ADO.NET Data Services

Universal calculated measures in MDX queries

Upgrading To SQL Server 2005 & 2008: Notes & Best Practices

What’s New in SQL Server 2008 T-SQL