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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-07-17 : 08:24:04
|
| Is it possible to turn off hyper threading using sql?I have checked sp_configure but it seems this does not have anythingto do with it.Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-07-17 : 14:25:59
|
| Hyperthreading set on or off in the computer's BIOS. The best you can do within SQL is to configure the CPU affinity to use only one of the two virtual processors--Gail ShawSQL Server MVP |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-07-17 : 14:29:37
|
| arkiboys what exactly are you trying to accomplish? because judging by your questions lately it looks like you want us to help you hack a server._______________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.0 out! |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-07-18 : 03:27:28
|
| Hi,What I am trying to accomplish is to make the task of the DBAs easier as follows:Each time the DBAs build a new sql server 2005 machine, they have to go through a standard checklist on that server. The checklist contains many many checks...i.e. version, spaces, DB checks, etc...A few of these I have not been able to do but you guys on this site have been very helpful.One of the few remaining check that I can not figure out is to ensure the hyperthreading is turned off.I will continue searching google for this.Thank you for your time... |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-18 : 03:30:02
|
Have you checked all *dm* views?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-07-18 : 03:46:28
|
| I will be doing a lot of reading then.Thank you |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-18 : 04:28:37
|
Good for you.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
hyper threading