Part 2 of this series is going to focus on Query Store and the execution statistics available to analyse performance. Without going into too much about query store, think of it as a flight recorder for the database its enabled on. The quickest way to take a look inside query store (when its enabled) is…

We’ve all been there in the trenches. You get the call ‘the app is slow’, and within 10 seconds management are breathing down your neck. Sometimes it feels like you need a crystal ball to figure out if there is indeed a sql issue, or rather its raining in somewhere and someone is just miserable.…