Here some data of our vm:
NUMBER OF VM: 1
RAM: 16 GB (static)
CORES: 4
HD: IDE, 150 GB.
Filesize (mdf): 5.92 GB
Filesize (log): 3.93 GB
The capacity of the cpu (VM) during the query is runnig is approx. 2 %.
I guess, the reason is not the CPU for being that slow. 😉
Maybe, we should choose another network configuration, because part of the work is done by the client.
Any idea ?