The Query Store only collects plans for data manipulation language (DML) statements, such as SELECT, INSERT, UPDATE, DELETE, MERGE, and BULK INSERT, as these are the T-SQL statements that will be responsible for most of our SQL Server's resource usage. Most database administrators (DBAs) are constantly looking for ways to optimize resource usage—after all, if T-SQL queries are using just the amount of resources they need (CPU, I/O, and memory), then SQL Server is operating at peak efficiency and allows for maximum concurrency with its current hardware resources.
This brings us to one of the main benefits of Query Store: tracking our workload heavy hitters—the most resource consuming queries. With this exercise, we may be able to uncover tuning opportunities that, if successful, further improve the efficiency of the server's resource...
