Tue, Sep 16 2014 11:00 Central Daylight Time
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 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.
JOIN PASS then add our Virtual Chapter to your list
Please join this site by creating a user account. This can be accomplished by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Please join this site by creating a user account. This can be accomplished by clicking the 'Register' link at the top of your screen or by clicking here. All registered users will be emailed detailed instructions prior to each meeting. Thanks!
Share your knowlede and skill, become a speaker. If you would like to speak at a future DBA Fundamentals event, please send us an email and we'll get back to you. We are looking for professionals with level 100 presentations in a wide variety of database administration topics. We look forward to hearing from you!!
Meetings At A Glance
Register - Rolling Upgrades, The Easy Way!
Tuesday, 08/19/14 -- Erin Stellato
Register - The Roadmap to Better Performance: Reading Query Plans