Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBKing
Starting Member
8 Posts |
 Posted - 2006-03-01 : 07:31:34
|
| HiHow can you identify if a windows machine is running hyperthreaded processors ?Regards |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-03-01 : 08:15:47
|
| Task manager will actually show them as seperate processors. |
 |
|
|
DBKing
Starting Member
8 Posts |
Posted - 2006-03-01 : 08:38:29
|
| I would like to know how many physical processors are on the box. Task manager will only show the logical processor usage. |
|
|
|
DBKing
Starting Member
8 Posts |
Posted - 2006-03-01 : 09:12:37
|
| Sorted: http://www.intel.com/cd/ids/developer/asmo-na/eng/microprocessors/ia32/pentium4/hyperthreading/19122.htm |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-03-01 : 10:09:53
|
| Several weeks ago we had Microsoft at our company doing a SQL Server Health Check. They came in and collected a ton of data on our servers and spent several days analyzing the data. They gave us 30 page report per server of what they found good and bad. What I found very interesting is what they had to say about hyper-threading. Here are their comments:Hyper-threading enabled on Windows 2000 serverIssue Urgency: Best PracticeDescription:Hyper-threading is enabled on processors on a server running Windows2000. Intel does not recommend enabling hyper-threading on Windows2000 servers.Risk:Windows 2000 is likely to schedule unrelated threads on the sameprocessor, not allowing it to leverage the registers and share information, and increasing the cost of atomic actions. The lack of efficient load balancing on Windows 2000 impacts optimal performance on hyperthreaded processors.Recommendation:Disable hyper-threading in the system BIOS setup program. For Intel’srecommended operating systems, seehttp://www.intel.com/support/processors/pentium4/sb/CS-017371.htmFor more information on how the lack of efficient load balancing canimpact hyper-threaded processors, see:http://www.intel.com/cd/ids/developer/asmona/eng/dc/threading/hyperthreading/20477.htm |
|
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
|
|
|
|
|
Hyperthreading