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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » How to check whether hyper thread is disabled...

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

Rate Topic

Display Mode

Topic Options

Author

Message

Joe-420121

Posted Tuesday, March 23, 2010 9:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:00 PM
Points: 107, Visits: 328

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.

Post #888255

MANU-J.

Posted Tuesday, March 23, 2010 2:25 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 1,654, Visits: 8,563

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

MJ

Post #888522

Joe-420121

Posted Wednesday, March 24, 2010 3:48 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:00 PM
Points: 107, Visits: 328

Thanks lot MJ.

Post #889390

yup

Posted Monday, January 14, 2013 2:54 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 4:12 AM
Points: 254, Visits: 714

try cmd shell & run

wmic cpu get numberofcores, numberoflogicalprocessors

Post #1406619

Joe-420121

Posted Monday, January 14, 2013 7:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:00 PM
Points: 107, Visits: 328

great DOS command, Perfect.. thanks a lot.

Post #1406699

« Prev Topic | Next Topic »

Permissions