Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

hyperthreding and NUMA

Posted on 2014-12-01
7
Medium Priority
?
102 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 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 52

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 52

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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 walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

722 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