I got lots of emails about how to set MAXDOP for any query. Today we will be learning 3 different ways to set MAXDOP. Let us learn it today.
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.
Not every problem is complex but all the problems are for sure interesting. Today we will discuss Visible Offline Scheduler and Performance.
The other day, I had a very interesting conversation with one of my clients about Scheduler_ID With a Large Number in dm_os_schedulers.