Data Mining SQLIO Results

Question

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

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

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

Jared Meaux SSC Enthusiast Points: 167 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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.