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.