In almost all my classes, and every time I do any performance consulting, I get the question "How can I determine if our SQL Server is hyperthreaded?" I was delighted when I found the DMV sys.dm_sys_info, which has a column called hyperthread_ratio. But
Read More...