I like to test my lab environment with NUMA. However, since it is not possible to simulate that in VMWare and getting my own physical hardware is too expensive. I have been thinking about using AWS.
After truing out different configuration, I finally got what I need with cr1.8xlarg
Here is the coreinfo output:
When check various DMV, it show up 3 nodes. Node 1 and Node 0 are real NUMA node. The Node ID 64 is reserve for DAC.
SELECT * FROM SYS.DM_OS_SYS_INFO;
SELECT DISTINCT MEMORY_NODE_ID FROM SYS.DM_OS_MEMORY_CLERKS;
SELECT * FROM SYS.DM_OS_MEMORY_NODES;
SELECT * FROM SYS.DM_OS_NODES;
select * from sys.dm_os_schedulers order by scheduler_id
The scheduler status “HIDDEN” is the scheduler that reserve for Database Engine.