SQL Server Performance Tuning and Optimization

SQW05 SQL Server Open Query Store

11/20/2019

9:30am - 10:45am

Level: Introductory to Intermediate

William Durkin

Data Architect

DData Masterminds

When SQL Server 2016 was released, it offered a fantastic new feature with the Query Store. Long term, statistics based, query tuning became a reality. But what about the thousands of servers that aren't upgrading to SQL 2016 or newer? The open source project Open Query Store is designed to fulfill that need.

This session will give a short introduction to the Query Store feature in SQL 2016 and then dive into the Open Query Store (OQS) solution. William (co-creator of the OQS project) will explain the design of OQS and demonstrate the features. You will leave this session with an understanding of the features of Query Store and Open Query Store, and a desire to implement OQS in your systems when you return to the office.

You will learn:

  • Demystify the inner workings of the Query Store
  • Show how to delve into the SQL Server engine
  • Empower attendees to explore niche features of SQL Server