• I enabled Query Store on a 3 TB sized database that is bulk loaded nightly. During the day it receives a fairly high volume of queries (ie: 100 per second) at a steady pace between 9am - 6pm from a call center application and also sporadic ad-hoc (sometimes overly complicated) queries from the BI and other data analysts throughout the day and into the evening. We do use SentryOne montitoring, which is great for a lot of things, but this tool is configured to only capture execution plan with a runtime > 10 seconds. For historical usage statistics on high volume sub-second execution plans, like the ones coming from the call center, I turn to Query Store.

    I wouldn't say it's the greatest thing to ever happen to SQL Server, data management views and plan guides were introduced back in 2005, but persisting the dmv data to a more star-schema data model is a big step forward and a foundation for building better query analysis and optimization tools.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho