Detecting Hyper-Threading state
Posted
by jchang
on SQL Blog
See other posts from SQL Blog
or by jchang
Published on Tue, 27 May 2014 17:23:00 GMT
Indexed on
2014/05/29
9:37 UTC
Read the original article
Hit count: 148
Filed under:
To interpret performance counters and execution statistics correctly, it is necessary to know state of Hyper-Threading. In principle, at low overall CPU utilization, for non-parallel execution plans, it should not matter whether HT is enabled or not. Of course, DBA life is never that simple. The state of HT does matter at high over utilization and in parallel execution plans depending on the DOP. SQL Server does seem to try to allocate threads on distinct physical cores at intermediate DOP (DOP less...(read more)
© SQL Blog or respective owner