Solved

hyperthreding and NUMA

Posted on 2014-12-01
7
101 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 20

Accepted Solution

by:
dsacker earned 167 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
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 333 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 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 333 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

628 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