.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

I have two Servers.

One has one processor and 6 slots occupied by Ram(set up and preconfigured by Manufacturer)

Another is on Two processors and 6 individual slots with 3 bars of ram on each, total of ( A1-A6 and B1-B6 ).

My question is although these servers came preassembled, and i have been told that the different A and B stols pertain to the different CPU's,

1.can we say that they are on NUMA?

2.How can we verify if a certain server is on NUMA? and if so how can we find out which type of NUMA it is?

3.Is NUMA configurable ?

4.Is Soft-NUMA, Interleaved-NUMA a hardware or software feature?

5.I believe we can have NUMA hardware enabled to behave as SMP.

5. Does NUMA look at the PHYSICAL Processor or the Number of Cores involved or the LOGICAL CORES due to HyperThreading?

Please help with details/BOOK REFERENCES.



View Complete Post

More Related Resource Links

CPU pressure and uneven NUMA load


Our client has hardware NUMA on their SQL Server box. There are 2 NUMA nodes and each contains 8 CPUs. At the beginning, things will run fine. But after a few days, we start to notice the CPUs belongine to one NUMA node (parent_id 1) are under more pressure (higher runnable_tasks_count). And the performance of our system will start to suffer.

This is a SQL Server 2005 64 bit environment. It is running SP2. The server has hardware NUMA. No affinity mask is set.It is also a dedicated SQL server box. There is no anti-virus software or OS job running on the box.

It is basically an OLTP system. It has very high traffic during certain hours in a day. What we noticed was that things never really went wrong in the middle of those busy hours. Instead, the system would all of a sudden go into problems during quiet hours. It then occurred to us we had some jobs scheduled during the quiet hours to move data around or delete obsolete data.

So our guess was that this problem could be caused by those jobs filling up the buffer pool or cache of one of the NUMA nodes (we have MAXDOP set o 1). That CPU then became slower when handling normal tasks because it has to do extra memory processing.

To confirm our guess, we have been flushing buffer and cache after all the jobs are complete in the past 2 weeks. So far the system seems to function properly.

The wa

SQL Server 2008 NUMA CPUs problem


Hello there,

I have three IBM x3950 M2.

Each IBM have four physical CPUs and each CPUs have 6 cores with 48GB of memory.
They are merged together so I have a host with 12 CPUs (72 Logical) and 144GB of memory.

I'm running Windows Server 2008 R2 Datacenter without any problem, my three NUMA nodes are detected.

The problem is with SQL Server 2008 Enterprise. It detect only 48 CPUs instead of the 72. The memory is detected correclty SQL report the 144GB.

In the ERRORLOG file I have:

Detected 48 CPUs. This is an informational message....
Node configuration: node 0: CPU mask: 0x0000ffffff000000 Active CPU mask: 0x0000ffffff000000.
Node configuration: node 1: CPU mask: 0x0000000000ffffff Active CPU mask: 0x0000000000ffffff.

From the view sys.dm_os_nodes I only have two nodes reported has online each report 24 online scheduler_count. I have a third node but it's for the DAC.

Since Windows is able to detect all CPUs I don't understand why SQL Server is not able to detect them.
So my question is how can I setup SQL Server to detect all my CPUs?

Thank you.


2008 SSIS and NUMA Memory issues and BLOB Data Types


We're running SSIS 2008, moving data from an Oracle 10g database to a SQL 2008 database.  The SSIS is running on the same machine as the SQL Destination server.  The server has 8 gigs and is windows 2003 sp2

The issue we're having is when our package pulls a blob data type from oracle it will just quit with no errors at about 1.4 million records.   We know there are 6 millions records in the dataset. 

A friend of mine said it was a NUMA Memory issue that it is running out at some point and SSIS thinks the incoming data is finished.  Unfortunately, she said there was no answer. 

I was wondering if someone else had a simliar situation moving blobs from Oracle?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend