One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.
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.
Today’s topic is very unique and one should not try it out without the proper consultation of an expert. How to Remove Unused Cache MARK_IN_USE_FOR_REMOVAL.