Review your favorite Linux distribution.
Go Back > Blogs > loadedmind
User Name


Rate this Entry

SAR graphing/plotting into Excel

Posted 10-02-2017 at 07:39 AM by loadedmind

First, I'll cite my sources that helped make this easier for me:

http://sebastien.godard.pagesperso-o.../tutorial.html - how to make a line graph in Excel

I've told sysstat to log the max history which is 30 days. Then, I use the following command to provide output of said disk I/O from the first day:
sar -b -f /var/log/sa/sa01
From here, I use sadf to output to Excel-friendly format:
sadf -d /var/log/sa/sa01 -- -b | sed 's/;/,/g' > storage01_diskio_1-3-17.csv
For the curious, here's what the output looks like, raw:

host1,599,2017-01-01 06:10:01 UTC,1.39,0.00,1.39,0.00,26.92

In Excel, I import the data to graph by copying/pasting the output from the previous command. From here, I click the Data ribbon and choose "Text to Columns".
From the new window that appears, I choose the "Delimited" radio button and click Next
I choose the "Comma" checkbox and click Next
"Column Data Format" should be set to General so I click Finish
I now insert a new line above it all for the following headers:
Hostname | Interval | Time | TPS | Reads/sec | Writes/sec | bread | bwrit
While still in Excel, I click the Charts ribbon, highlight all data and choose Scatter->Smooth Marked Scatter.
Lastly, I choose Layout 1 from "Chart Quick Layouts"
Posted in Uncategorized
Views 14048 Comments 0
« Prev     Main     Next »
Total Comments 0




All times are GMT -5. The time now is 01:55 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration