# Troubleshooting: Using Query Store to monitor query performance in Business Central
## What is SQL Server Query Store?
The SQL Server Query Store feature provides you with insight on database query plan choice and performance. It simplifies database performance troubleshooting by helping you quickly find performance differences caused by query plan changes. Query Store automatically captures a history of queries, plans, and runtime statistics, and retains these for your review.
## Where is SQL Server Query Store available?
SQL Server Query Store is available in SQL Server (starting with SQL Server 2016) and in Azure SQL Database.
## What are the common scenarios for using the Query Store feature?
Query Store keeps a history of compilation metrics and runtime statistics aggregated over time intervals. It isn't a log of every individual query execution. With this information, you can get answers to questions about your workload, such as:
 Which n captured queries ran most recently?
 What was the number of executions for each query?
 Which queries had the longest average execution time within the last hour?
 Which queries had the biggest average physical IO reads in the last 24 hours, with the corresponding average row count and execution count?
## Do you want to read more?
Learn more about setting up, configuring, and using Query Store in the following articles:
https://learn.microsoft.com/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store
Operating the Query Store in Azure SQL Database<https://learn.microsoft.com/azure/sql-database/sql-database-operate-query-store>
## Related information
../deployment/installation-considerations-for-microsoft-sql-server

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/troubleshoot-query-performance-using-query-store, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/administration/troubleshoot-query-performance-using-query-store/
