I have a question on one of my new build sql servers where we are planning to migrate our SQL databases from older SQL2012 running on windows 2012.
New build- SQL2016 on Windows 2016
My current [SQL2012]==> When querying os_nodes dmv shows what i am assuming as 4 numa nodes config with memory
node id=0,1,2,3 &
processor group 0,1,0,1 and
scheduler count= 20 for all id's
My new [SQL2016]==> When querying os_nodes dmv shows what i am assuming as 8 numa nodes config with
memory node id=0,0,0,0,1,1,1,1 &
processor group 0,0,0,0,1,1,1,1 and
scheduler count= 9 for all id's
Below is O/P from os_nodes dmv between old and new configured SQL servers
When viewed via task manger/ssms it shows 2 Numa nodes. Is my above understanding wrong of 8 Numa nodes?
If those are 2 Numa nodes will i have any performance impact compared to current setup?
softnuma_configuration_desc shows ON for sql2016