|02 Jun 2009||#1|
| || |
VM disk optimisation using Databases
I can't seem to find an answer to this but if I want to use a "transactional" data base system on a Virtual machine is there any way to optimise the Virtual Disk system.
I know that the WHOLE allocation area should be done initially -- allowing Virtual disks to "grow" in the usual manner is a real Death-knell for running any decently sized DB on a virtual machine.
I'm not sure whether I should set the Virtual Disk as SCSI or IDE either -- documentation seems very sparse on this.
Another possible solution is to use "RAW" or "Physical" disks - but these are quite difficult to set up.
I'm trying to set up a SAP IDES system to run on a Windows XP Virtual machine (this application won't run on VISTA or Windows 7) with ORACLE as the underlying DB system.
The Oracle Database system it uses is around 80GB. I've plenty of disk space but any time the Data base Dirctionary is accessed it seems to take a long time. The Virtual machine runs just fine and the SAP system response time is perfectly OK until some DB queries run.
I've already optimised indexes etc etc and the table spaces are fine. I'm sure it's just something in the Virtual I/O subsystem that is causing the problem.
There's around 3.5GB RAM allocated to the VM which is running on a 16 GB RAM QUAD Q9400 processor system -- CPU power and RAM is not an issue.
Any ideas anyone.
|My System Specs|
|Similar help and support threads for2: VM disk optimisation using Databases|
|Back up databases.||Backup and Restore|
|system optimisation: assistance with deleting vista||Installation & Setup|
|hard disk boot failure insert system disk press enter||General Discussion|
|databases obsolete?||System Security|
|SSD Optimisation - move Appdata\Local\Temp?||Performance & Maintenance|
|Disk boot failure, please insert system disk and press enter||Hardware & Devices|
|Dreamweaver CS4 Databases ERROR - Was once connected||Software|