system stats gathering

[Rosli Ahmad]

Hi,
I need to gather memory,CPU and other resources utilization on daily basis for my monthly server performance report (Excel graph). I was told that there's this /usr/lib/sa/sa1 utility that would do the job, but the manpages are don't seem to help me much. Would appreciate if someone could give some description of sa1 or other utilities I could use to generate my report. Thank you in advance.

rgds
-rosli-

[Tom Geudens]

Hi,
From our own crontab (on every system)
# Collecting System Activity data
00 * * * * /usr/lbin/sa/sa1 900 4
05 22 * * * /usr/lbin/sa/sa2 -s 7:00 -e 19:01 -i 3600 -A

These collect and generate the same kind of reports you can also make manually with sar (try man 1m sar for more information).
The results will be put in directory /var/adm/sa.

Regards,
Tom Geudens

[Michael Tully]

Tom has given what you need for 'sa', one more suggestion though, you might like to load the glance plus pak trial copy available on your applications CD which will give you a 60 license in which to use it. It is not that complicated and gives more statistical information than you could possibly imagine. Many things that 'sa' will not report.

[Stefan Farrelly]

Theres only 2 ways to do graphs of performance stats;

1. Use a high level (pruchaseable) software performance package, like HP's PerfView (and Measureware agent). This does fantastic graphs of almost anything imaginable. Costs a bit though and you need to purchase agents for all servers you want graphed. You can use software like this from other companies, eg BM Patrol, Sitescope etc.

2. Use sa do to simple stats which you then need to graph yourself in something like Excel. This is free but will take a fair bit of work to get up and running and to produce the graphs.

Tools like HP's Glance only run in realtime - you cant view historical data like you can with the 2 options above.

[Elena Leontieva · Accepted solution]

Rosli,

I attached two scripts that run on my system daily to collect the system's activity information. From the daily report created by the second script you can extract what you need to generate a data to import into Excel.

Elena.

[Elena Leontieva]

This is the second one.

[Rosli Ahmad]

Thannk you everyone for the contribution.

rgds
-rosli-