The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Login to Subscribe

Event Display
Meeting Detail

Tue, Sep 16 2014 16:00 UTC


The Roadmap to Better Performance: Reading Query Plans

RSVP: https://attendee.gotowebinar.com/register/3935830875052414466

The Roadmap to Better Performance: Reading Query Plans

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 Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids