Whether you’re a DBA or a developer, you probably know that when you submit a query to SQL Server it generates a plan – a map if you will – that determines how it will get the data you’ve requested. But if you’re not familiar with how to read that map, then how do you know how to create a faster route to the data? How can you tune a query?
If you’ve been lost when looking at plans before, then sign up for this session where we will cover the basics of query plans. We’ll step through how to capture them, discuss the essential information to review in a plan, and highlight a couple patterns to look for when tuning queries. As usual, expect lots of demos to highlight key points, and “plan” to walk away with new methods to use when reviewing query plans in SQL Server. Level: 200
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.