Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

SAR Analyzer



Hi,

This tool also I have developed it with VBA+Excel, this is for create pivot and normal charts from SAR file. The input is the file with all information about the performance metrics on linux S.O (Oracle Linux or Red Hat).  For every metric inner file the VBA will make new Sheets and charts about that metric.

For Instance, in the first page "Inicio" you will see the next one:



There you have the button "Ejecutar analisis de SAR" for open the SAR File and the date format from SAR File. After press that button "Ejecutar analisis de SAR" the VBA code begin to create new sheets with pivot charts, for example:


In That Pivot Charts you can select for example only the core number "0",  and you will see only that behavior for that core. Here other analysis examples (memory, swap, disk, network, etc..):





Here for example we have analysis for every Disks (with Pivot):


Other example for network (every interface):


Here you can download the last versión:
https://drive.google.com/file/d/1_XMrxU3izAtTXc8txS_bt22eEX5CPCcV/view?usp=sharing

Pls don't change the code VBA and don't change my copyright.
My email for any comment: felipe.donoso@oracle.com and felipe@felipedonoso.cl

Bye :)
Felipe.


Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com | Free Blogger Templates