New Release and now Open Sourced

VisualAWR has been an interesting project for me while at Oracle.  A great use case was for assessing customer DB workloads for health and capacity planning during Excite 20/20 engagements.  Since moving on to AWS, I see opportunities to use this tool for assessing workload sizing (CPU/Mem/Storage/IOPS) for migration the cloud.  Migration to cloud could mean lift-and-shift to RDS (Oracle flavor) or migration to other relational databases.  Both approaches will need to know historical resource consumption for sizing of infrastructure required to run a database in the cloud, which is where this tool comes in.

I have uploaded a new version which now allows Batch processing of AWRMiner files.  See download option to the right.

I have also opensourced this project on github:  https://github.com/sfurlong/visual-awr

Looking forward to continued collaboration with folks interested in this project.

New Version of Visual AWR v02h!

It has been a while since I've had time to publish new features.  I have been doing a fair amount of customer Exadata utilization assessments lately.  I always find AWR and Visual AWR an indispensable tool for getting a quick read on the health and utilization of production database workloads.

The major change in this release is a Summary Report.  This will provide a quick overview of the essential metrics for the overall system.  The Summary Report aggregates essential metrics from all RAC instances.  This is where you should start your first pass at analyzing the target platform.  After this, choose one of the detailed reports that will show you the behavior of each individual RAC instance for a particular metric.

Also in this release you will see a new report for database Size On Disk.

See the link to the right to get the latest version -->>

Hope you find this project useful.  As always, let me know your experience using it and if you have other features you would like added.

Since I do allot of work on consolidating workloads on Exadata, the next feature I'm looking at is to combine multiple workloads into one chart to see how they would look on the consolidated target platform.

Over 1000 downloads in the past 12 mos.

Hit the 1000th download last month.  Although I have been immersed in the NoSQL world for the past many months, this has been an interesting project for me.  Drop me a note to let me know how it is working for you and any features you think should be added.  Have fun with VisualAWR.

New Release v02f. Printing of Charts now Supported.

Printing of charts is now supported.  Also exporting of AWRMinor and OSWatcher data sets is now supported.  Many other smaller feature enhancements and bug fixes.

Added new Feature to Export OSWatcher data in new release v02e

The capability to Export aggregated OSWatcher/ExaWatcher data has been added.  Also numerous other smaller enhancements have been added for better reporting.

New Release of VisualAWR v02a Now Supporting OSWatcher/ExaWatcher

This new Release Supports TopStat and IOStat metrics collected by OSWatcher or ExaWatcher.  When using to report on IOPS from Exadata Storage Cells, a separate chart for FLASH and DISK can be generated.

Visual AWR tested on Solaris

Visual AWR has now been tested on Solaris SuperCluster and used to chart databases running on a SPARC SuperCluster.  Charting Direct from DB was used.