jasona.work (12/19/2014)
(I think some of the L2 and L1 cache, various other bits and bobs)
Each core has it's own L1, at least with the Intel processors. L2 is 'shared' (kinda, one core can't flush the entire of L2), L3 if present as well.
Reason multiple cores is better than multiple processors is to do with the inter-core communication. With them really close together, there's less delay in communications between them.
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