August 16, 2011 at 3:55 am
This was removed by the editor as SPAM
August 16, 2011 at 5:46 am
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?)
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
August 16, 2011 at 5:58 am
Great question. I've learned a lot about NUMA in the last few weeks.
http://brittcluff.blogspot.com/
August 16, 2011 at 6:42 am
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
August 16, 2011 at 7:48 am
Great question Steve. Definately learned something new about NUMA. I have yet to use this or see it being used.
August 16, 2011 at 8:19 am
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[/url]
Learn Extended Events
August 16, 2011 at 8:57 am
Thank you for the question.
Is there any chance to simulate soft-NUMA on a dual-core?
Regards,
Iulian
August 16, 2011 at 9:47 am
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.
August 16, 2011 at 10:03 am
Tom.Thomson (8/16/2011)
There's unsatisfactory user interface here: i
completely agree. There ought to be better interfaces here
August 16, 2011 at 10:50 am
Great question. NUMA is something I had never heard of before this series of questions and I'm certainly learning a lot.
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
August 16, 2011 at 11:23 am
Thanks for the question. I learned something while trying to figure it out.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
August 16, 2011 at 1:33 pm
I know this is slightly Off Topic, but anyone else notice that there are a lot less QOTD responders on Tuesday's?
August 16, 2011 at 6:15 pm
good question... totally agree that the reg edit is far from ideal too.
August 16, 2011 at 10:49 pm
very good question
M&M
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply