?
Solved

hyperthreding and NUMA

Posted on 2014-12-01
7
Medium Priority
?
107 Views
Last Modified: 2014-12-02
Hi Experts,

can you help me how to find out if I am using HYPERTHREDING and NUMA.
Where can I check these settings ?
0
Comment
Question by:Eprs_Admin
  • 4
  • 2
7 Comments
 
LVL 20

Accepted Solution

by:
dsacker earned 668 total points
ID: 40474073
A good read on hyperthreading is:

Another good read on NUMA is:

The chart in the first link shows a comparision of the sockets to the number of cores. It is not complete, in that you may have more cores. You'll need to compare the following query with information you can run from the Command Prompt:

SQL Server Query:   SELECT cpu_count/hyperthread_ratio AS sockets FROM sys.dm_os_sys_info
Command Prompt: wmic cpu get numberofcores, numberoflogicalprocessors
The Windows Resource Monitor, CPU Tab, shows info on NUMA.
0
 

Author Comment

by:Eprs_Admin
ID: 40475320
the SQL query -> 2 sockets

But what does it mean ?
0
 

Author Comment

by:Eprs_Admin
ID: 40475321
The WMIC result ->

Number of cores
4
4

Number of logical processors
4
4

What does this means ?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 53

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1332 total points
ID: 40475480
You can run the following query:
SELECT cpu_count AS LogicalProcessors, 
	cpu_count/hyperthread_ratio AS PhysicalCPU
FROM sys.dm_os_sys_info

Open in new window

The cpu_count returns the number of logical processors and the divide it by hyperthread_ratio to return the number of Physical CPU.
0
 

Author Comment

by:Eprs_Admin
ID: 40475569
ok I know my physical CPUs -> 2
0
 

Author Comment

by:Eprs_Admin
ID: 40475579
...and with COREINFO, nothing is written about hyperthreded.

With this link I can see I have 4 cores per CPU:
http://ark.intel.com/products/33087/Intel-Xeon-Processor-X5460-12M-Cache-3_16-GHz-1333-MHz-FSB

2CPU -> 8 Cores

When I use MAXDOP 0 or MAXDOP 8, it is the same in my case. Both settings say -> use 8 cores.

Ok thanks so far , I think I know now what it means.
0
 
LVL 53

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1332 total points
ID: 40475589
MAXDOP -> 0 means to use ALL processors
MAXDOP -> 8 means to use 8 processors

If you have 8 processors (2x4) then you won't see any difference between MAXDOP 0 or 8 because it's ALL of your processors.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

OfficeMate Freezes on login or does not load after login credentials are input.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question