sotn (12/27/2012)
For NUMA harware, every SQL Server I've looked at, in processors, says NUMA node 0 etc and then split into the cores/processors. does this mean it is NUMA enabled?
More like NUMA aware. SQL Server will see the NUMA nodes as they are presented by Windows per the hardware. If there is no NUMA present you'll still see Numa Node 0 as the only CPU grouping.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato