Windows 7 Forums


Windows 7: VM disk optimisation using Databases

02 Jun 2009   #1

W7 X-64 RTM,SUSE 11.1, XP PRO SP3 as a VM, VMware ESXi
Hafnarfjörður IS
 
 
VM disk optimisation using Databases

Hi all
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.

Cheers
jimbo

My System SpecsSystem Spec

Reply

 VM disk optimisation using Databases problems?



Thread Tools



Similar help and support threads for: VM disk optimisation using Databases
Thread Forum
system optimisation: assistance with deleting vista Installation & Setup
databases obsolete? System Security
Solved SSD Optimisation - move Appdata\Local\Temp? Performance & Maintenance
Dreamweaver CS4 Databases ERROR - Was once connected Software


All times are GMT -5. The time now is 10:07 AM.


Seven Forums Android App Seven Forums IOS App Follow us on Facebook

Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32