My blog post SQL SERVER – 3 Queries to Detect Memory Issues. Lots of people wanted me to create a video on this topic – get memory details.
Earlier I wrote a blog post about SQL SERVER – List Expensive Queries – Updated March 2021. Let us learn how to Find Expensive Queries.
One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.