NUMA optimization?

what's new numa in sql server?

is there way reading, sql server or perfmon or hardware vendor tools or vm tools, of how crossing numa boundaries, , costing?

the "numa management" trick know setting maxdop @ or below number of cores on physical processor.  guess rest supposed automagic.

is there else 1 can see or regarding numa?

thanks,

josh

what's new numa in sql server?

nothing know. numa was introduced scale-ability overcome limitations of smp system.the biggest shared memory bus requests use use same memory bus. introduction of numa system each numa nodes not have there own memory , possibly own i/o channels.

is there way reading, sql server or perfmon or hardware vendor tools or vm tools, of how crossing numa boundaries, , costing?

the readings should interest local , foreign memory readings. local memory memory of node process can access while memory allocated other nodes process wants access foreign memory. cost associated foreign memory access high need monitor that.

you need see counter sql server:buffer node object , in can see

1. database pages

2. foreign pages.

for more information must read growing , shrinking bpool under numa

jonthan kehayias has written more numa

---

please mark reply answer if solved issue or vote helpful if helped other forum members can benefit

my technet wiki article
mvp

SQL Server  >  SQL Server Database Engine