Understanding the Benefits of Microsoft Query Store

Microsoft introduced the Query Store when they released SQL Server 2016 and it can track statement performances, pinpoint queries and more.

DBTA recently held a webinar focused on the new features and what to expect. The webinar included experts such as Jason Hall, senior sales engineer at Quest, and Anat Dror, SQL Server and DB2 domain Expert at Quest, who discussed the limitations of the new tool and how to best leverage the product.

Before SQL Server 2016, users understood query performance by performing traces, and searching extended events and DMV’s, Hall explained.

Now, with the Query Store it can automatically capture a history of queries, plans, and runtime statistics; performance data is retained during a restart; information is aggregated over different time intervals; it works for natively compiled procedures and in-memory OLTP queries; is supported on all SQL Server editions; and is enabled at database level.

In addition with the Query Store users can see their queries at the statement level where query text is given. The tool can retain queries over time and restarts, can aggregate by time windows, and works for in-memory OLTP and disk-based workloads.

The new tool is easy to use; highly customizable to support various use cases and workloads; contains granular customization at database level; is easy to manage at query level; has automatic storage management; and more, Dror said.

“This is easy to use without a preliminary plan,” Dror said. “With Query Store you can see all different types of queries.”

An archived on-demand replay of this webinar will be available here.