May 30, 2014 at 5:10 am
Can anybody please explain how can i check whether we have any hard NUMA or Soft NUMA on my system. i have attached screen shot to help(NUMA.bmp)
What does Memory node id = 0 and 64 mean ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 30, 2014 at 5:37 am
Hi, memory node id 64 is a logical node to support the Dedicated Admin Connection. It's not associated with any physical NUMA node.
From your screen shot I would say that you do not have any NUMA configuration set up (although someone may want to confirm that for me). What type of processor do you have on the system?
May 30, 2014 at 5:52 am
The error log lists the NUMA setup. Post that.
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