Query Store - A New SQL Query Tuning Feature

Abstract:

Have you ever come in to work only to have the boss come tell you that your main site is down and the database is "broken"? Fixing query performance problems can be rough, especially in high-pressure situations. Microsoft has developed a feature to help customers gain significantly easier insight into production systems and to be able to quickly fix cases where a new plan choice from the query optimizer has undesired performance consequences. This talk introduces the Query Store, explains the architecture, and shows how it can be used to solve real-world performance problems. It will now be possible to ask questions like "show me what query plans have changed since yesterday" and to quickly ask the optimizer to "go back" to the query plan that was working fine for you previously.

Speakers:

  • Conor Cunningham

    2 Recordings
    Conor has been working on building database engines for 25 years at Microsoft. He has worked on features such as the Query Store, Table Partitioning, Window Functions, PIVOT/UNPIVOT, DMVs, and many others. Conor served as the Breadth Architect for shipping SQL Server 2016, 2017 and 2019 and still serves as an architect across the engine on challenging architectural issues. Conor is based in Austin, Texas (USA) and also serves as the Engineering Site Leader as we build a new engineering site there. His team there recently delivered a number of T-SQL language extensions into SQL Server 2022 and SQL Azure as well as doing the AVX-512 performance improvements that shipped in SQL Server 2022. Currently he is working on Synapse Data Warehouse and future database architectures.

Recorded At:

Recorded on:

Jan 31, 2015

More Info:

https://www.sqlsaturday.com/viewsession.aspx?sat=362&sessionid=26468

Tags: