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.
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.