Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Exgliderpilot
Starting Member
14 Posts |
 Posted - 2010-09-14 : 11:45:29
|
| Like a lamb to the slaughter we upgraded a 2005 Express VM to 2008 R2 at first it seemed fine, then the users compained of poor performance. The database was now above 4GB so no going back. Performance was degrading, we noted the VM only had 512 ram, reconfiguered to 3GB and the machine ground to a halt Literally - more than 1 user could not log on. A simple query would MAX the processor to 100% for 2 or 3 seconds. No stored proceedure was a standout as a bad performer. Only one user could log in at a time. All indexes were rebuilt (took 4 hours!) still unusable performance. Move the machine to a single processor xp with 2GB ram and 8 users can now log on simutaneously CPU bumps along at 5-20%. Av is off on the data folders. Is SQL 2008 R2 Express a no no on VMware? Should we recommend against SQL 2008 R2 upgrades?Staff bank ageny software http:\\www.ava.co.uk |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sk55
Starting Member
4 Posts |
Posted - 2010-09-18 : 09:03:08
|
| what version of vmware are you running esx4?how many vcpu do u have allocated?what is your disk subsystem?We run sql 2008 (not r2) on a few VM works fine when designed properly. |
 |
|
|
|
|
|
Performance issue SQL2008 Express R2 vs vmWare