http://sqlblog.com/blogs/linchi_shea/archive/tags/NUMA+affinity/default.aspxTags: NUMA affinityenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/linchi_shea/archive/2012/01/30/performance-impact-the-cost-of-numa-remote-memory-access.aspxMon, 30 Jan 2012 23:17:20 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41450Linchi Shea10http://sqlblog.com/blogs/linchi_shea/comments/41450.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=41450These days if you get a new server-class machine to run SQL Server, you can almost be 100% sure that it’ll be running on NUMA hardware. The recent AMD Opteron and Intel Nehalem-based processors are all built on some form of NUMA architecture. The current...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2012/01/30/performance-impact-the-cost-of-numa-remote-memory-access.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=41450" width="1" height="1">PerformanceBenchmarkMemory speedNUMANUMA affinityRemote memory accessLocal memory accesshttp://sqlblog.com/blogs/linchi_shea/archive/2012/01/28/no-respect-numa-affinity-meets-query-parallelism.aspxSat, 28 Jan 2012 05:32:51 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:41396Linchi Shea6http://sqlblog.com/blogs/linchi_shea/comments/41396.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=41396What happens when NUMA affinity meets query parallelism? It gets no respect! SQL Server allows you to affinitize a TCP port to a specific NUMA node or a group of NUMA nodes. Books Online has an article on How to: Map TCP/IP ports to NUMA Nodes . And this...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2012/01/28/no-respect-numa-affinity-meets-query-parallelism.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=41396" width="1" height="1">parallelismNUMAport affinityNUMA affinitybug