Query Store architecture
Query Store is integrated with the query processor of the database engine. The simplified architecture diagram is shown in the following diagram:
Figure 9.2: Query Store architecture
Query Store actually has two stores:
- Query and Plan Store: Stored information about executed queries and execution plans used for their execution
- Runtime Statistics Store: This store holds aggregated execution parameters (execution time, logical reads, and so on) for executed queries within a specified time
Both stores have instances in memory and persisted representation through disk tables. Due to performance reasons, captured info is not immediately ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
