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: Today @ 12:02 PM
Points: 32,830, Visits: 14,971
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


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: Today @ 5:04 AM
Points: 3,694, Visits: 4,827
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: Monday, April 21, 2014 8:44 AM
Points: 1,633, Visits: 2,038
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: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:47 AM
Points: 8,296, Visits: 8,750
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,232, 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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:20 AM
Points: 20,484, Visits: 14,140
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1160561
Posted Tuesday, August 16, 2011 8:57 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 6:49 AM
Points: 861, Visits: 793
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: Yesterday @ 6:43 PM
Points: 3,158, Visits: 1,901
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: Today @ 12:02 PM
Points: 32,830, Visits: 14,971
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