Press "Enter" to skip to content

Finding Single-Use Queries

Erik Darling visits the used query lot looking for some low-mileage models:

This metric gets looked at a lot in the plan cache to see how effective it is. The main problem is that with high enough churn, you might not catch all the queries involved in the problem. Here are a couple ways to look at this in Query Store.

Click through for the queries.