A little background:
We have a windows service which gets data from an external server and stores them on a local DB (SQL server 2012).
The external server sends more than 1500 “messages” per second, but our storage rate is almost 500 msg/s for the local server ( the windows service and database are on a single VM with Xeon E5520 and 16 GBs of RAM on a HP G7 Server/ windows server 2012).
When I move the service and DB to my local PC, the storage rate rises to 1100 msg/s.
I did the test on multiple PCs (core2 duo and core i5) and Servers (HP G7 and G8, VM and physical servers), the result was the same: all PCs get messages in a way better rate than our servers.
We thought It might be a network problem, but it was not.
I did a “Memory Transaction Throughput” test with “Sisoft Sandra” on Servers and PCs and figured out that our PCs do a much better job than the servers . the minimum PC result was 5.4MTPS (on a core2 duo E7400), the maximum server result was 3MTPS (on a HP Proliant DL380P with Xeon E5-2650).
I tend to conclude that there’s something wrong with Xeon processors, but that would be a strange conclusion since there are dozens of Xeon DB Servers around the world.
Am I missing something? Is there a special configuration on the BIOS to solve this problem?