This was first published on https://blog.dbi-services.com/measuring-iops-on-xtremio (2015-09-07)
Republishing here for new followers. The content is related to the the versions available at the publication date
Today, we can put our database on very efficient storage. EMC XtremIO is one of them. In this blog post, I’ll show how to look at the IO performance from Enterprise Manager, Orachrome Lighty, and XtremIO client interface.
The XtremIO client has a nice dashboard that show immediatly the IO rate:
The instant view shows 120 KIOPS here and details on the block size. The history show that the rate can be sustained. This is not a production workload. I took the screenshots while dbms_resource_manager.io_calibrate was running
Of course, you want to see the io_calibrate output:
max_iops = 122935 latency = 3 max_mbps = 3084
There is one information – the most important one for Auto DOP – that is not displayed but we can check it here:
SQL> select * from resource_io_calibrate$; MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY NUM_DISKS ---------- ---------- ---------- ---------- ---------- 122935 3084 1364 3 2One process can sustain 1.3GB/s. This do not depend on the storage but on the server. That is coming from an ‘old’ E5-2667. I can run a lot of processes and I’ve a 4 nodes RAC. The storage can sustain 3GB/s And we have reached 120 KIOPS.
The storage here is one EMC XtremIO one X-Brick.
The ‘Real Time’ view of Lighty show basic info from V$ views, calculating deltas and showing them graphically. So here are the figures from the database:
Of course you can see the same figures from Enterprise Manager f you have Diagnostic Pack:
ASM comes with performance metrics as well and can be seen from Enterprise Manager:
Performance is not the only feature of XtremIO. You have compression as well. These performance figures come from a database that takes only 35% of its size:
If you have read compression ratios from EMC marketing, then you have here a proof that you can achieve that compression ratio on a regular ERP (only numbers and some text. No images, no documents.)
Compression without performance overhead is a great feature of XtremIO. There is another one: snapshots without performance overhead on source. But that is for another time.