So if I can’t modify or add indexes and I can’t change code, how do I get my query times to drop? Query Store to the rescue.
I love to tune queries. I feel so satisfied to see the times dropping on my server as I tune things. Recently, I have been tracking my Batch Requests per Second and my Instance Waits to see if I am making improvements when I tune. It has been awesome!
What I am going to show you today is how I dig into my query store to find those misbehaving queries and make their performance better.
Click through for some high-level tips on how to use Query Store.