Post reply

Data Mining SQLIO Results

  • March 26, 2013 at 12:01 am

    #272145

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

  • March 26, 2013 at 8:18 am

    #1600823

    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.

    http://www.meauxsoft.com/SqlioAnalyzer.html

    Thanks,

    Jared Meaux

  • March 26, 2013 at 9:57 am

    #1600883

    input this URL:

    ( http://www.buy2me.us/ )

    you can find many cheap and high stuff

    ===== http://www.buy2me.us/ =====

    WE ACCEPT CREDIT CARD PAYMENT

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

  • March 26, 2013 at 1:39 pm

    #1600950

    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