OpManager slow

Hi there,

I am more often experiencing OpManager running very slowly at random intervals, as an example I could click on a link and it may take several minutes for that link to come up.

The server that runs OpManager is as follows

Dell Poweredge 750
Pentium D 3.2Ghz
2GB RAM
Fujitsu SCSI 80GB hard drive partitioned into three

The processor is dual-core and I notice that when OpManager is running slowly, mysqld-nt is 100% utilising one of the processors so it's obviously busy doing something.

Is there any way we can determine what it's doing and why it takes so long? Is it also possible to tune the SQL db's performance to better utilise the CPU? Also do you have any other ideas as to what the issue might be or how we fix it?

Thanks,
Lee de Souza