sar2csv is a tool which generates a csv(comma separated values)-file from text-sar-files(generated by "sar -A") for Linux.
If you have binary sar files, sadf command which is provided by sysstat package is so useful to do same as this. ksar is another great tool which generates a graph from sar binary files.
However, this tool is still useful for the unfortunate case you do not have binary sar files but only have text one.
| package name | SRPM package | RPM package(for RHEL/CentOS/OracleLinux 5/6/7) |
|---|---|---|
| sar2csv | sar2csv-0.3-1.src.rpm | sar2csv-0.3-1.noarch.rpm |
This is mainly for RHEL5/6/7 including RHEL clone distoributions(ex. CentOS, Scientific Linux, Oracle Linux).
Just install sar2csv package like:
# rpm -Uvh sar2csv-0.3-1.noarch.rpm |
You may need perl module "Time::ParseDate" before installing sar2csv. The module can be installed from CPAN by running command "cpan Time:ParseDate", or install the module by installing appropriate rpm package below which includes it.
| Distribution | PackageName | example where you can get |
|---|---|---|
| EL5 | perl-Time-ParseDate | External Package |
| EL6 | perl-Time-modules | Standard Package |
| EL7 | perl-Time-ParseDate | External Package |
If you need csv file which is generated by all existent sar files on /var/log/sa/, just run "sar2csv /var/log/sa", Then you can get sar-XXXX.csv where XXXX is random charactors. For example:
# sar2csv /var/log/sa Processing sar file "/var/log/sa/sar25"... Processing sar file "/var/log/sa/sar26"... Processing sar file "/var/log/sa/sar27"... Processing sar file "/var/log/sa/sar28"... Processing sar file "/var/log/sa/sar29"... Processing sar file "/var/log/sa/sar30"... Processing sar file "/var/log/sa/sar31"... Generating .csv file: "sar-84lt.csv" Done. # |
usage: sar2csv [options] sar_datadirs_or_sar_files
description:
This script generates a csv file from sar text files(output of
'sar -A -f /var/log/sa/sa01').
options:
-o <output_csv_file>
--output <output_csv_file>
This specifies the csv file which is generated by this
command. default = "sar-XXXX.csv"
XXXX will be filled with unique characters not to overwrite
existing files.
--nonamecheck
This specifies "do not check filename". By default, this
script check filename whether it is "sar[0-9][0-9]" to
decide if it is a valid sar file. However, with this
option, this script just try to analyse any files as a
sar file.
|
here(4MB) is the CSV file which is generated by sar2csv. The server logged the sar files has 4 CPUs and several block devices, you can see the data for each cpu/block-device are separatedly corrected.
in a support bbs or e-mail.