November 9, 2011 at 3:30 pm
http://msdn.microsoft.com/en-us/library/ms345357.aspx
Im trying to get a grip on soft numa with the above article. It states that in the example they are creating 3 soft numa nodes, but i can see only two nodes being created.
As the two soft nodes are the same, i would assume they would have the same number of IO and lazy writer threads.
I ask as i want to ensure i understand it correctly and im not sure if its the article or my understanding thats incorrect.
Thanks!
November 9, 2011 at 11:55 pm
It's Correct.
CPUs 1 2 3 4 5 6 7 8
Soft-NUMA <-N0--><-N1-><----N2---->
SQL Server <instance A ><instance B>
CPUs 1-4 are allocated to Instance A with Node0 & Node1.
CPUs 5-8 are allocated to Instance B with Node2.
Instance A, which experiences significant I/O, now has two I/O threads and two lazy writer threads, while instance B, which performs processor-intensive operations, has only one I/O thread and one lazy writer thread.
November 10, 2011 at 3:21 am
It is incorrect, but not quite in the sense you asked.
The article states: 'Instance A, which experiences significant I/O, now has two I/O threads and two lazy writer threads, while instance B, which performs processor-intensive operations, has only one I/O thread and one lazy writer thread.'
The error here is that soft NUMA does not give extra Lazywriter threads and that IO thread it's talking about is actually a network IO thread
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply