On the server
- download the version 1.0 of sarbi
- upload it on a linux/unix hosts with SH shell and SAR tool installed (this is a wrapper for SAR, you cannot go far without it)
- edit the LOCALE variable used inside the script (actually the default is itIT, you may change it in enEN or anything else)
- run the sarbi.sh like sar , with all your command line parameters like the following example.
EXAMPLE this will collect disk access statistics for 60 times, with 1 second pause between each other (substantially monitor disk usage for a minute):
./sarbiv10.sh -d 1 60 > /tmp/sarbi.diskaccess.csv
On your workstation
1. download and install PowerBI (if you already don't have it
https://powerbi.microsoft.com/)
2. download from this prokect the
.pbix file that fit your analysis (in the example, since you're collecting disk access statistics, you need the
disk_access.pbix file) and open it in your powerbi installation
3. download the
.csv file generated by
sarbi on the remote host
4. click the
modify query button in the ribbon, it will open a new window with the "query editor" view
5. click in the
advanced editing button in the ribbon i the "query editor" window
6. you will see something like this :
Origine = Csv.Document(File.Contents("C:\utility\sarbi\data\........csv"),[Delimiter=";", Encoding=1252]),
the only thing you have to change is the path to your csv file
7. confirm the editing in the
advanced editing window8. click on the
close and apply button to apply modification and engage the data reload