Free Webcast: Reading Execution Plans for Performance Tuning

Wednesday, January 25, 2017, 1:00 PM Eastern

 
 

Webcast Overview

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. The, we will answer questions like the following. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

Your registration includes:

On-demand viewing for 7 days following the event
Access to the virtual event video content

Not sure you can attend? No problem, all the video content will be available on-demand for 7 days.

Sessions


All times are Eastern Time Printable Schedule || Times, presenters and sessions are subject to change.

12:30 PM
-to-
1:00 PM


Track:
Room 1
add_alert
Add to Calendar

Welcome


 

 

 


1:00 PM
-to-
1:52 PM


Track:
Room 1
add_alert
Add to Calendar

Reading Execution Plans for Performance Tuning


Thomas  LaBlanc

 

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. The, we will answer questions like the following. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?