Can you guys please suggest some tools which can monitor everything about Web and DB Server?Few of details I need to track are as follow:

Disk Cache Swap used Swap free Network RX Network TX IO read IO write No. apache processes Load manager factor Max apache Busy pages

Hello,

You can monitor all of the above and much more with Nagios. Or if you're not comfortable with CLI you could go with GroundWork which is build around Nagios and uses JBoss engine.

Nagios
Groundwork Open Source
NagiosExchange Plugins

Kind regards,

Eric

I did installed Nagios and tried monitoring the local system.
I have a webpage running on this localhost.
But I can see not much info being displayed when I click HTTP.
Can You recommend how can I add info like

Disk Cache Swap used Swap free Network RX Network TX IO read IO write No. apache processes Load manager factor Max apache Busy pages

Hello,

Have a look at NagiosExchange (link in previous post) where you can download tons of plugins for a variety of checks. Searching for apache on their site gave this. I'm sure you'll find a plugin that does exactly what you need. As for the memory have a look at check_mem.pl plugin from the same site.

Kind regards,

Eric

EricTRa...Thanks for suggesting me with this tool..
Let me tell you whats issue I am facing with..
I have been recommended with Monitoring Tool which will retrieve the column wise representation of Web and DB Server.
Those column do display the data like:

Disk Cache Swap used Swap free Network RX Network TX IO read IO write No. apache processes Load manager factor Max apache Busy pages

Now these and more I need to capture from Nagios.
Is this possible?
Till Now I have only followed the link:http://nagios.sourceforge.net/docs/3...rt-fedora.html and installed nagios and nagios-plugin.

I want more info mentioned below from HTTP.

It's true that Nagios is not a big reporting and/or graphics tool. It's a monitoring tool and that's what it does best, monitor and alert you. If you need to 'present' the data you collect there are various reporting tools for Nagios out there, NagVis being one of them. And basically if you'd want to write your own scripts to organize the data Nagios collects then you can. The data is all in plain text file (have to look where it's kept, believe in log, not sure though).

But again, with the plugins from NagiosExchange and the ones that come with Nagios itself, I bet you can monitor 98% of what you want/need if not 100%. Just try it out, play with it.

Kind regards,

Eric

And for statistical information/trend analysis combine it with cacti ...

cacti or munin can do this quite well