I am attempting to study the impact of increasing the server memory on SQL Server. I am running BMF TPC-C with a number of users (I started with 90 & 100 virtual users), limiting the SQL Server memory to simulate server memory at 16GB, 32GB, 64GB, 96GB and 128GB.
I had expected to see better performance at the larger memory sizes, but the TPS stayed the same with different memory sizes. This tells me that the 100 users is not enough to stress the system. I got the license for 1000 virtual users and my results with 900 & 1000 are about the same (linear) with fewer users.
Is there a way to increase the load with 1000 virtual users or do I need to increase the virtual user count. Also, what is the max number of virtual users that I can use?
The data base scale is 7,000 warehouses. This is running on a Dell R910, with two CPUs (Xeon E7-4850 @ 2.0 GHz)