4 NUMA Support MSSQL Server in AWS

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:

SQL Server

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.

 

Reference

http://blogs.msdn.com/b/psssql/archive/2011/11/11/sql-server-clarifying-the-numa-configuration-information.aspx