My results from SQLIO are just wrong. I have a 6 drive RAID 10 array with SAS disks 10K RPM. SQLIO is saying I am getting max of 8000+ IOps. I am using a 10,240MB file, random read, 1 thread per file, 4 Outstanding IOs, 4-32 request byte size.
How do I prevent caching? HP 400 controllers have 100% read cache only (no-battery backup I just found out). Windows 2008 enterprise. You can't turn the cache off on the controller.
Thanks, Chuck
Why would you want to disable caching? Cache speeds things up. What IO speed do you think you should be getting?
When using random IO, your performance will be way less than when using sequential IO. Sequential IO is what is used to get the performance numbers that the vendors publish.
The numbers that you receive from SQLIO with caching are what you're going to get from the system, so is that an issue? You'll run with caching anyway, so that should work OK. Have you run a test with vendor software to check RAW throughput and confirm what you are getting?