Press "Enter" to skip to content

Short Query Store Queries

Mala Mahadevan has a few short-ish Query Store scripts for us:

I use Query Store a lot where I work ā€“ and Iā€™d like to share queries I use on Query Store DMVs that I find incredibly useful.

My favorite is one below, which I use to see stored procedure duration. It comes with other information including plan id, start and end time ā€“ all of us help me see red flags right away if there is any query not performing as well as it should.

Click through for that script as well as two more.