My machine is running on Window 2012 R2, with 48 Logical processors and 240GB RAM.
I have create a VM with 48 processors and 230GB ram.
I am double about the NUMA nodes I should create and memory assign to each nodes. By click a the 'Hardware Typologic', it create 24 nodes with 2 processors each. Currently I have set to 2 NUMA node per socket, each NUMA node with 12 processors, and 65GB or RAM per each NUMA.
The problem I am facing is the SQL server(Window 2008 + sql 2008) performance. It can take 1-2 seconds when processing few hundred of line in a batch. But, it could use the same times when processing few lines. The performance is up and down.
I need some advice on the NUMA configuration based on the processors and RAMS i assign to the VM.