Investigating Plans with Query Store

Investigating Plans with Query Store

In the past, you had to execute custom scripts to gather information from either dynamic management views or extended events to tune badly behaving queries.One major enhance made in SQL Server 2016 was the addition of the query store. With a simple ALTER DATABASE statement, the database engine captures this data in memory and asynchronously writes this information to the database. This means that a simple reboot of your server does not cause you to lose all those valuable statistics.SQL Server Management Studio has been enhanced with screens and reports to identify this bad queries. Once you know the problem, you can start work on fixing it.Last but not least, the live query statistics feature introduced in SQL Server 2016 allows you to see how a long running query executes.In short, the query store is one tool that a database administrator can’t live without.

BIO:

John Miner is currently a Microsoft Technology Solutions Professional (TSP) advising North East District (NED) corporations on how to solve their business needs with data platform solutions. He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems. His credentials include undergraduate and graduate degrees in Computer Science from the University of Rhode Island. He has also earned certificates from Microsoft for Database Administration (MCDBA), System Administration (MCSA) and Data Platform (MCSA). Before joining Microsoft, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community. When he is not busy informing the members of current events at a local PASS chapter, he spends time with his wife and daughter enjoying outdoor activities.