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?