Query Store is my favorite way to gather information about problem queries and plans, and I wanted to share some information on the useful metrics I use most.
The first two are obvious, but there’s a difference between them. The last two are not obvious but offer an unusual utility. I also wanted to explain why I use logical reads and mostly ignore physical reads.
Read on for Jared’s list.