Data Mining SQLIO Results

• Paul Brewer

  SSCrazy

  Points: 2955

  More actions

  March 26, 2013 at 12:01 am

  #272145

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

• Jared Meaux

  SSC Enthusiast

  Points: 167

  More actions

  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

• buyme207

  SSC Rookie

  Points: 37

  More actions

  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!!!;-);-);-)

• Ray Herring

  SSCertifiable

  Points: 5533

  More actions

  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.