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.
Well, let us figure out the answer to this question in today’s blog post where I will be doing a performance comparison of 16 CPU vs 1 CPU.
I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.
During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.