I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.
I have an interesting experience to share about the Query Ignoring CPU Threads. I was hired by a large eCommerce organization.
He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.
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.