Hello,

I made some test series with the combination of the db showing apparently slow query execution times, sql server 2008 r2, windows server 2008 r2 running a vm under hyper v as well as under the host itself.

The database size is approx. 6 GB.

The test-server (host) has 32 GB Ram and a 8 core cpu.

Interestingly the lack of perfomance is appearing only under the virtual machine.

This shows quite impressively that the reason for the bad performance is not the db it self.