Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

NUMA Expand / Collapse
Author
Message
Posted Monday, August 15, 2011 9:22 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:55 PM
Points: 31,278, Visits: 15,736
Comments posted to this topic are about the item NUMA






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1160345
Posted Tuesday, August 16, 2011 3:55 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:07 AM
Points: 4,100, Visits: 5,456
Great question, thanks
took a fair amount of reading to get this, so I learned something new.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1160438
Posted Tuesday, August 16, 2011 5:46 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 9:31 AM
Points: 1,890, Visits: 2,192
Thanks for the question. Had to dig a bit, but it was worth it. Starting to like NUMA. If I had a daughter, I think I'd name her that. (Rhymes with Uma Thurman?)

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1160461
Posted Tuesday, August 16, 2011 5:58 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Great question. I've learned a lot about NUMA in the last few weeks.

http://brittcluff.blogspot.com/
Post #1160468
Posted Tuesday, August 16, 2011 6:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:38 AM
Points: 7,850, Visits: 9,600
Good question.

But it's sort of easy; you are telling sql server which CPUs it is allowed to use (alter server configuration set processor affinity); and you are telling the system how SQL Server is to see that collection of CPUs as split into (soft) NUMA nodes (by registry manipulation).

There's unsatisfactory user interface here: introducing registry entries with regedit or reg merge. It would be nicer to do this with a soft-numa-specific GUI and a soft-numa-specific command line, each of which could check for idiocies like using a mask which would assign CPUs from different hard numa nodes to the same soft numa node or putting a processor into more than one soft numa node. It would prevent errors arising from mistyping those long keys, and could either raise an error message if the GROUP is not specified for 2008 R2 (not needed for 2008 or 2005) or if a nonexistent group is specified, or alternatively provide a default group number (0, because most systems will have 64 or fewer CPUs).


Tom
Post #1160487
Posted Tuesday, August 16, 2011 7:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,228, Visits: 1,046
Great question Steve. Definately learned something new about NUMA. I have yet to use this or see it being used.
Post #1160543
Posted Tuesday, August 16, 2011 8:19 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 12:45 PM
Points: 17,947, Visits: 15,941
Nice question. Too bad manual edit of the registry is required still.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1160561
Posted Tuesday, August 16, 2011 8:57 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, November 13, 2014 3:36 AM
Points: 1,012, Visits: 1,000
Thank you for the question.

Is there any chance to simulate soft-NUMA on a dual-core?

Regards,
Iulian
Post #1160592
Posted Tuesday, August 16, 2011 9:47 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 12:24 PM
Points: 3,384, Visits: 2,017
Nice question. I too am concerned with editing the registry to make it work though. I agree with Tom's comment on having a GUI specifically for this. Maybe we will see that in a future release.
Post #1160625
Posted Tuesday, August 16, 2011 10:03 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:55 PM
Points: 31,278, Visits: 15,736
Tom.Thomson (8/16/2011)

There's unsatisfactory user interface here: i


completely agree. There ought to be better interfaces here







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1160641
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse