Session
Getting Started with Execution Plans
Abstract
There are times when
you are able to be proactive and tune existing queries. Sometimes, you will
receive a phone call from your manager telling you that a certain web page or
report is timing out and your users are furious. You need to quickly diagnose what
the problem is. Where do you turn to first? When a query is underperforming,
hogging resources or timing out, one of the first things you want to examine is
the query execution plan. An execution plan provides a wealth of information
that can help you quickly diagnose what is wrong. In this beginner level
session you will learn what an execution plan is, how to find it, and how to
interpret it to see what the query optimizer is doing and find the major pain
points.
Bio
Jason Kassay is a database developer/administrator, web application programmer and speaker from Colorado with over 10 years of experience. He is passionate about SQL Server and performance tuning and optimization. Jason is an active member of the SQL Server community and has volunteered at events such as the Colorado GiveCamp, SQL Saturday's and the Denver SQL Server User Group. When not tuning databases, Jason will most likely be found playing hockey or running.
Meeting Details:
January 23rd, 2014,
2PM ET
GoTo Webinar: https://attendee.gotowebinar.com/register/3767566008751180801