Data Mining SQLIO Results

  • Comments posted to this topic are about the item Data Mining SQLIO Results

  • I have been using SQLIO as a tool to estimate storage performance capacity for a few years. Its a great tool - really flexible and powerful. The biggest cost for me has been analyzing results. For my tests I don't do anything fancy. But I do need to analyze results easily & quickly, to compare one storage subsystem/RAID Array/SAN against another.

    So, I put together this Windows program. Just open your SQLIO result .txt file for quick analysis. If anyone wants to use it, its freeware.


    Jared Meaux

  • input this URL:

    ( )

    you can find many cheap and high stuff

    ===== =====


    YOU MUST NOT MISS IT!!!;-);-);-)

  • It is true that RAID 5 typically shows well in Random Read Testing. However, even a small amout of write activity can quickly tip that apparent advantage over RAID 10. I/O ratios as low as 90:10 R/W can be significant depending on strip/block sizes etc.

    Additionally, default RAID5 often consists of just 3 disks which makes matters even worse.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply