I am testing how one of our stored procedure is working on
SQL Server Standard vs
SQL Server Enterprise editions.
I have created two virtual machines and install a
SQL Server 2014) and restore a database on each instance. Then I have generated some test data (large volume but the same on each database) and started testing if there is an execution time difference.
I have been told that there should be
4x better performance on the
Enterprise edition when a large volume of data is used because there is NUMA Aware Large Page Memory and Buffer Array Allocation.
So far, there is no such difference and the execution time is almost the same (a
+ second difference).
I cannot say I understand completely what is
NUMA and how it works, but I guess the hardware
NUMA is on as the following query returns me
SELECT DISTINCT memory_node_id FROM sys.dm_os_memory_clerks
I am not interested in the software
Could anyone tell if such
4x optimization really exists and should I continue generated more data in order to see it?
This is the
VM set up: