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.
Sunday, December 31, 2017
Wednesday, April 5, 2017
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.
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.
Subscribe to:
Comments (Atom)