Improve Performance by Automating the Query Store

Chad Crawford

The Query Store is an amazing tool that allows you to manage query plan performance like never before. However, monitoring and maintaining the query store is still largely a manual process. As a result, most DBAs waste time on anti-patterns: they use Query Store for only the very worst queries, miss countless small queries that have a significant impact in aggregate, and never come back to review old plans to ensure they are still good. You don’t have to fall into this trap! This session will unveil and examine eight scripts that take the Query Store to the next level using mathematical statistics (i.e. not the table stats) and customizable logic. I’ll help you stop spending time worrying about query plans and focus on being more efficient!