BOOK-CHAPTER
Query Store
Abstract
The Query Store is a feature that was introduced in SQL Server 2016, which captures the history of queries, their plans, and statistics. It allows DBAs to easily view the plans that were used by queries and troubleshoot performance issues. In this chapter, we will discuss how Query Store can be enabled and configured. We will also examine how the Query Store can be used to diagnose and resolve performance issues.
Keywords:
Troubleshooting Computer science Query optimization Query by Example Sargable Database Feature (linguistics) SQL Information retrieval Query language Sql server Web query classification Stored procedure Spatial query Web search query Search engine Operating system
Metrics
0
Cited By
0.00
FWCI (Field Weighted Citation Impact)
0
Refs
Citation Normalized Percentile
Is in top 1%
Is in top 10%