5 pts.
 Oracle 10g on Windows 2003 virtual server
We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

Software/Hardware used:
ASKED: March 25, 2008  9:45 AM
UPDATED: May 17, 2008  12:31 AM

Answer Wiki:
Running any database in a Virtual machine (either VMware or Microsoft) will not perform well under load. Virtual Machines use virtual disks for storage which adds an additional layer of processing which has to happen before the data can be written. In addition your memory and CPU are not all your own, so this can cause more slow down. Virtualization is great for Dev and QA database servers. I usually don't recommend it for production database servers, especially ones that will be using a large amount of load. This is a patently wrong answer. VMware VI3 runs Oracle and SQL Server just fine. In VI2, the virtual machine was limited to 2 procs and 3.6GBs of memory, and it VI3 the virtual machine can have up to 4 procs and 64GBs of memory and with the lastest release supports jumbo memory pages for cacheing in memory. I would suggest you go to www.vwware.com and search on Oracle and get up to date.
Last Wiki Answer Submitted:  May 17, 2008  12:31 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.