Managing Query Performance: Plan Forcing and Query Store Hints ~ Erin Stellato

Nov 17, 2021 · Burlington, United States of America

Intermittent performance issues can be a DBA's nemesis. You don't know when the problem will occur, it can be tricky to capture the right data, and once the issue has been identified, you may not be able to make the change to fix it.

Enter Query Store. With Query Store, you can continually capture query performance data, quickly pinpoint the issue, and then manage the performance by forcing a plan or adding a hint, even without code access. In this session, we'll explore manual and automatic plan forcing, and the new Query Store Hints feature, to see how easy it is to stabilize performance in both Azure SQL Database and on-prem solutions.

ABOUT THE SPEAKER

Erin Stellato is a Data Platform MVP and lives in Cleveland, OH. She has over 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, Query Store, 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 including SQLintersection, SQLBits, and the PASS Summit. Outside of time with family and friends, she enjoys running, reading, movies, and all things chocolate.

Event organizers

Are you organizing Managing Query Performance: Plan Forcing and Query Store Hints ~ Erin Stellato?

Claim the event and start manage its content.

I am the organizer
Social
Topics