When Microsoft brought out Query Store, they wrote:
Similar to an airplane’s flight data recorder, Query Store collects and presents detailed historic information about all queries, greatly simplifying performance forensics by reducing the time to diagnose and resolve issues.
I have a straight face under here, for real
It certainly works, making it easier for you to understand when a query’s execution plan suddenly goes downhill, taking your server with it.
But it isn’t enough.
In airplanes, it’s not enough to know that the throttles were powered down and the altitude plummeted. It’s not enough to know what happened: we need