Triad SQL Servers Users Group (TSSUG) – July Meeting
Date: Tuesday, July 28th, 2015
Time: 6pm – 8pm (Eastern Daylight Time)
Location: Dynamic Quest HQ, 4821 Koger Blvd, Greensboro, North Carolina
Scott Fallen Presents Getting Started With Execution Plans
Speaker: Scott Fallen, Sales Engineer SQL Sentry, LLC
Summary: Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.
About Scott: Scott Fallen is a member of the Sales Engineering team at SQL Sentry, makers of the award winning Performance Advisor and Event Manager monitoring tools. In this role, he teaches customers and evaluators how to utilize SQL Sentry’s tools to monitor and improve the performance of their SQL Servers.
About Triad SQL Servers Users Group
TSSUG is a forum for Microsoft SQL Server database administrators and developers. Our goal is to provide a forum to meet similar individuals, learn about the product, and share ideas. Our group is run by SQL Server professionals for the benefit of anyone interested in participating in the group.
All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Servers. Our meetings are generally held on the last Tuesday of every other month, unless otherwise noted. Pizza and drinks are provided.