Follow sqlserver-dba.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

SQLServer-DBA.com Links

Dba_db2_button

dba-ninja.com

SQL Server DBA Jobs

How can I tell if hyperthreading is on Windows 2012

12 October,2016 by Tom Collins

Question: One of the prerequisites of an application install is to have SQL Server 2012 Enterprise Installed .There are also some OS based prerequisites. One of these is to have hyperthreading turned off. I’ve spoken to the server engineers who’ve confirmed hyperthreading is turned off from the BIOS.

How can I check from the OS if hyperthreading is turned off?

When I check in the SQL Server Error Logs there is an entry at SQL Server start up which although gives some information doesn't fully answer my question  :

SQL Server detected 1 sockets with 14 cores per socket and 14 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing.

 

Answer: The method I use involves wmic (Windows Management Instrumentation) . A widely used command is :

                      Wmic CPU Get NumberOfCores,NumberOfLogicalProcessors /Format:List,

If the Number of Core equals the number of logical processors is the same hyperthreading is turned off.

NumberOfCores=14

NumberOfLogicalProcessors=14

 

The alternative method is to use Amount of sql server processors with sys.dm_os_schedulers


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on How can I tell if hyperthreading is on Windows 2012


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer