As a DBA, how many times you hear about a user reporting that a query suddenly running more slowly than in the past? SQL Agent job usually takes 3 hours , but this is running more than 12 hours, Could you please investigate? What would you do in this case? There are number of commonContinue reading “Query Store – Key feature in SQL Server 2016”