Mrdenny 
46795 pts. | May 15 2008 7:57PM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
Q:
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
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
ASKED:
Mar 25 2008 9:45 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
