While analyzing Write-Back cache activity on Exadata storage cells, I wanted something to interactively monitor IO while I was running various tests. The problem is summarizing the results from ALL storage cell. So, I decided to use my old friend “iostat” and a quick easy script to roll up the results for both DISK and FLASH. This allowed me to monitor the IOPS, IO size, wait times, and service times.
The “iostat-all.sh” tool shows the following data:
day time device r w rs ws ss aw st
2013-06-24 14:40:11 DISK 47 40252 54 2667941 66.15 0.28 0.07
2013-06-24 14:40:11 FLASH 9 40354 322 2853674 70.70 0.13 0.13
2013-06-24 14:41:13 DISK 48 39548 80 2691362 67.95 0.31 0.08
2013-06-24 14:41:13 FLASH 9 53677 324 3975687 74.06 0.14 0.13
Hopefully this will be useful for those that like to dive into the weeds using our good old friends.
Published April 9, 2013
Tags: Exadata, Oracle
MAA tests on Exadata… demystifying availability tests
I have not had a lot of time to post recently due to various reasons and a switch in jobs at Oracle. I currently am 100% dedicated to working in the Oracle Solution Center to help customers test the performance on Oracle’s engineered solutions. So, why am I sending this link?
Regardless of the performance tests that are performed, I often spend a fair amount of time showing the Availability aspects as well. Hopefully this video will help to demystify the availability aspects of Exadata.
With the acquisition of Sun quickly approaching, I decided it was time to get a personal blog to discuss Oracle performance on Sun. I have maintained a blog at Sun for the past 3 years, so I am not new to the powers of blogging. I want to continue to post material during the transition and not have to come up to speed on another blogging platform and the required logistics. Blogging helps me discuss current trends regarding database performance in real-time as well as preview and refine material that eventually becomes a presentation or white paper.
Why did I choose WordPress?
The are multiple reasons. The functionality is one of the best in the business. The interface is smooth and intuitive which allows you quickly express yourself. Also, for the past 5 months I have been working closely with an old friend Kevin Closson on Exadata V2 performance. Kevin is an avid blogger on WordPress as well… So all-in-all, WordPress seemed a natural fit.