Got a Windows 2008 VM running Oracle 11g. Storage is provided to the guests via thick provisioned VMDKs.
IOMeter performance is fine but Oracle storage calibration test shows very poor performance. PerfMon shows the application running with a queue depth of only 2 IOs, hence the issue.
Oracle function is per the standard code:
SET SERVEROUTPUT ON
DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (2, 20, iops, mbps, lat);
DBMS_OUTPUT.PUT_LINE ('max_iops = ' iops);
DBMS_OUTPUT.PUT_LINE ('latency = ' lat);
dbms_output.put_line('max_mbps = ' mbps);
end;
/
Have run it from EqualLogic storage and local DAS and tried all three virtual SCSI adapters. Performance is low in all cases:
Running from 16-drive EqualLogic - 600 IOPS (IO-Meter running 4,400 IOPS at 64 IOs)
Running from 5-drive 10k DAS - 400 IOPS (IO-Meter running 1,300 IOPS at 32 IOs)
Any ideas would be greatly appreciated!