1

In our office, we have a Windows 2008 virtual machine hosted on an HP ProLient ML350 G6. This VM has access to all of the resources available on the host.

On this machine there are some Microsoft Access databasess which are used in a poorly coded vb6 application that runs on our PCs (currently 25-30).

Our problem is that sometimes the queries we use (which are also poorly coded) are slow as hell.

Can the VM have something to do with this problem? How can we debug this?

I was thinking about checking disk I/O but I'm not sure what I should check exactly, CPU and memory usage are very very low.

We are, of course, trying to write better code, but in the meantime we are trying to see if there are other problems with our structure.

HopelessN00b
  • 54,273
SilentRage47
  • 125

1 Answers1

6

First: MS Access performance is terrible. It's not made to have any performance, so the DB counts a lot.

Second: if you run a non performatic DB on a VM, you will have another performance penalty.

Third and most important: if the application is poorly coded and with terrible engineered queries, there's nothing you can do on hardware that would make the system perform better.

Generally, performance tunning the software wields way better results than changing the hardware. If you want to speed up the system, switching from MS Access to a real DB would make some difference, and rewriting the code will give you the biggest performance boost. Only after those two changes you will have to take a look on the hardware and VM.

ThoriumBR
  • 5,427