Plan Stability through Plan Forcing with Query Store


Details
Before the summer break we will held this meeting in a different way. I am excited to announce that this meeting will be a remote presentation held by Erin Stellato.
About the topic:
Intermittent performance issues due to parameter-sensitive queries are a DBA's nemesis. By the time you're notified of an issue, sometimes it's gone away...or someone else has restarted the instance or cleared the plan cache, and any data you could use is gone. Capturing the different plans for those queries can be tricky, but with Query Store it becomes very simple - the hard part is deciding what plan you like best. The Query Store feature, introduced in SQL Server 2016 and also available in Azure SQL Database, captures query performance data, and it allows you to manually force a plan for a query. In SQL Server 2017 and Azure SQL DB, the Automatic Plan Correction feature will force plans for you. Sound scary? It's not. In this session we'll explore both manual and automatic plan forcing through demos so you understand how it works, what to expect, and what to watch out for when you implement it in your environment.
About the speaker:
Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure 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 like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Email: Erin@SQLskills.com
Website: http://www.SQLskills.com
Full Bio: http://www.sqlskills.com/about/erin-stellato/
Blog: http://www.SQLskills.com/blogs/Erin
Twitter: http://twitter.com/ErinStellato
SQL Server MVP since 2012
Agenda:
17:45 - 18:00 - Registration
18:00 - 18:15 - Intro
18:15 - 19:15 - Presentation
19:15 - Pizza by Infobip
Thanks to our event sponsor!
Infobip is a global cloud communications company and a leader in omnichannel engagement enabling a broad range of messaging solutions for advanced customer engagement, authentication and security.
Quality engineering is the backbone of everything they do.
To build great customer solutions on the edge of innovation means they hire, grow, and retain the best engineering talent across the world. Over the last 10+ years, they grown into an Engineering Powerhouse employing 1500 people, across 60+ offices on six continents, that help us change the world with our products and solutions. Throughout 2019, the company plans to recruit an additional 250 engineers and 250 developers - https://infobip.com/careers

Plan Stability through Plan Forcing with Query Store