How to check whether hyper thread is disabled using SQL Server query

• Joe-420121

  Hall of Fame

  Points: 3152

  More actions

  March 23, 2010 at 9:40 am

  #143710

  It is confusing from Windows side to check from BIOS whether hyper threading is disabled. is there any easy way to check from SQL Server query whether hyper thread is disabled (or whether hyper thread is recognized by SQL server or not). any DMV?...pls help thanks in advance.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 23, 2010 at 2:25 pm

  #1138553

  Good read-->http://sqlblog.com/blogs/kalen_delaney/archive/2007/12/08/hyperthreaded-or-not.aspx

  MJ

• Joe-420121

  Hall of Fame

  Points: 3152

  More actions

  March 24, 2010 at 3:48 pm

  #1139282

  Thanks lot MJ.

• yup

  SSCarpal Tunnel

  Points: 4490

  More actions

  January 14, 2013 at 2:54 am

  #1576803

  try cmd shell & run

  wmic cpu get numberofcores, numberoflogicalprocessors

• Joe-420121

  Hall of Fame

  Points: 3152

  More actions

  January 14, 2013 at 7:00 am

  #1576869

  great DOS command, Perfect.. thanks a lot.

• October 18, 2022 at 6:16 am

  This was removed by the editor as SPAM

• October 18, 2022 at 6:19 am

  This was removed by the editor as SPAM