Query Store - A New SQL Query Tuning Feature
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.
Conor Cunningham is a Principal Software Architect at Microsoft on the SQL Team. He is an expert on query processing and optimization, data warehousing, cloud architectures, and distributed systems design. He has been at Microsoft over 16 years and has worked on both SQL Server and SQL Azure building new features and leading efforts across numerous teams. He loves talking to customers to see how they use the products and services Microsoft builds so that he can help improve them.
- Austin SQL Saturday 27 Recordings
- SQL Tuning 1 Recording