Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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
 
 
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




Thread Tools



Similar help and support threads for2: VM disk optimisation using Databases
Thread Forum
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
Solved 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

Our Sites

Site Links

About Us

Find Us

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

All times are GMT -5. The time now is 09:19 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

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 33