ESM running slow
I will try to quick write down my problem, if there are any questions I’ll try to answer. We are having real problems with Oracle base, because is running slow. Last hour event takes about a minute, last 2 hour takes 4, daily reports about 15 minutes,… ESM 4.5 SP2 is installed on HP DL 360 G6 server (quad core, 12 gb ram) with Red Hat x64. When I look top in terminal it shows a small amount of memory free, in graphical mode like task manager is showing completely different statistic. Does anyone have any idea what should be problem for slow running? Performances of server or Oracle? I aslo try to run scripts SetDynamicSampling and GatherSystemStats but no improvements. Are there any tips and trick that should be done when installing and how to tune Oracle base?
Performance could be in one of several areas but more information is needed:
1. What is sustained peak Events Per Second (EPS) encountered on the manager
2. What is daily average of event rate on the manager?
3. When you stated "ESM is installed on...." was that just the Manager, both the Manager and the Database Server, or are the Manager and DB running on the same server?
4. What type of storage are you writing to? (Size/Speed/RAID layout)
5. How many simultaneous users are on the system during the slow periods?
For Linux installs, you might find the following helpful:
I'd look at other factors like storage layout, DB template used, manager installed on same server as DB, etc before modifying the Oracle database settings. The ESM install guide has a lot of good tips on getting better performance from your system.
Disclaimer: Im not a Oracle datbase administrator and know only general information about it based on our Environment and information provoded by our database Admin team.
I know in our environment when we initially had performance issues. The Database team re-indexed the tables and this dramatically increased the performance. If you have never done this on your database, you may want to look into doing it. I can also say the first time this was done, I saw an improvement on performance of 10. IE: active channels would complete after 15 minutes before the re-index, only took 1.5 minutes. but it also requires a Looooooong time to re-index initially. I think it took us 12 hours or more if I rmember right.
Just my 2 cents.