Hi Adai,
Thanks for getting back to me. I have been working on this for a while, even opened a case couple of times but nothing has really helped. Just installed the 5.0.2P1 patch which was running good for about 5 mins after which it has slowed down again. I am constantly seeing at least one core of the server being pegged and the dbsrv10.exe process using about 25% CPU. It seems to me the delay is being caused by the sybase database. Prior to installing the 5.0.2P1 patch I did use the dfm purge utility as well.
What version of OCUM/DFM are you running currently ?
5.0.2P1 on Windows 2008 R2 SP1 x64
Is your server a VMware ?
Yes
If so what is the memory and CPU configuration ?
4 vCPU, 6GB RAM (played around with different configs to test but none have helped)
Are they reserved or allocated ?
Yup, I have 5GHz reserved for CPU and 6GB for RAM
How many dataset are currently there ?
113
How many controllers are being monitored ?
8
Is Performance Advisor also Enabled on the same server ?
Was initially, I disabled it in hopes of improving performance, but didn't help.
Regards,
Usman