Understanding NUMA in SQL Server VMs

What really is NUMA and why do we as database administrators care?

NUMA stands for “Non-uniform Memory Access” and allows for increased CPU & memory performance.  This is because a memory bank is physically adjacent to a CPU socket on the motherboard of the server.  Each combination of memory and socket is considered a “node”.  If demands of a request (think query) forces it to go outside the bounds of a given node then the request could encounter slower performance.

Share

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?