sar report format help

[Raymond Ford]

In an attempt to determine system stats on a SUN 250e while Veritas NetBackup v3.4 ran over this past weekend the following entry was made in crontab: 0,15,30,45 23-6 * * 5-1 /usr/bin/sar -ubgkpqr 15 >> /veritas/veritas.load. I got the results I expected every 15 minutes from 11PM to 6AM, but in the following format:05:30:00 %usr %sys %wio %idle
bread/s lread/s %rcache bwrit/s lwrit/s %wcache pread/s pwrit/s
pgout/s ppgout/s pgfree/s pgscan/s %ufs_ipf
sml_mem alloc fail lg_mem alloc fail ovsz_alloc fail
atch/s pgin/s ppgin/s pflt/s vflt/s slock/s
runq-sz %runocc swpq-sz %swpocc
freemem freeswap

05:30:15 2 36 47 15
0 3 100 0 0 100 0 168
0.27 0.27 0.27 0.00 0.00
2670592 2088436 0 27516928 23436728 0 7217152 0
0.13 0.00 0.00 2.66 4.33 0.00
1.0 7
1247 1144963

All the data matches up, but I can't work very well with it.

Question: Can anyone help me to format this data? My best guess is to import it into perhaps MS Excel, but I've met with little success. Second I wonder if the options I used with sar are necessarily the best to determine how much of the SUNs capacity NetBackup uses.

Thank-you in advance to all who may use your time to help me work through this one.

[PIYUSH D. PATEL]

Hi,

You can check this site and you can definitely acheive a good format.

http://forums.itrc.hp.com/cm/components/FileAttachment/0,,0x826187dc4d7dd5118ff00090279cd0f9,00.htm

Piyush

[MANOJ SRIVASTAVA · Accepted solution]

Hi Terrence

The o/p should read be read like this :
05:30:00 %usr %sys %wio %idle
05:30:15 2 36 47 15


bread/s lread/s %rcache bwrit/s lwrit/s
0 3 100 0 0

%wcache pread/s pwrit/s
100 0 168


pgout/s ppgout/s pgfree/s pgscan/s %ufs_ipf
0.27 0.27 0.27 0.00 0.00

sml_mem alloc fail lg_mem alloc fail vsz_alloc fail
2670592 2088436 0 27516928 23436728 0 7217152 0

atch/s pgin/s ppgin/s pflt/s vflt/s slock/s

0.13 0.00 0.00 2.66 4.33 0.00

runq-sz %runocc swpq-sz %swpocc
1.0 7

freemem freeswap
1247 1144963


The o/p is like this bcoz the o/p wraps aroung the end of line, the easier way would be to run each option seprately and append it to the same file or different files and then import it to excel ,

or you can use sarcheck from www.sarcheck.com who give a one month free trial s/w and produce th o/p in a formammted form . I ahve a ttached a report from that s/w for one of our systems.



Manoj Srivastava

[Pavel Hampl]

Hi Terrence

for store of sar data is better to use standard /usr/lbin/sa/sa script. This script collecting all sar data into /var/adm/sa directory and you can go through them later by sar command.

You have to put sa1 script into the crontab for instance like this:
0 * * * * /usr/lbin/sa/sa1 300 12

Afterwards you can use sar with an arbitrary option. You can also specify the range of the time which you like to show otherwise in the ouptput will be only actual day.


Regards,