Strange behavior on VM machines

Hardware platform:

  • MS Web server 2008
  • One VM processor
  • SQL Express Edition
  • Standalone RB webedition

Situation:

SQL query (select statement) sets processor load 100% utilized by standalone RD web server. Result SQL query timeout is generated. When we add a second CPU in de VM machine problem is solved. System is not out of memory, only CPU is 100% loaded till we receive SQL timeout.

Same application is running perfect on non VM machines.

Any suggestions?

Have at least 2 cores CPU and 2Gb RAM allocated to VM and check again. Give more power and fine tune decreasing resources after.