SQLIO Disk Testing

Question

Post reply

SQLIO Disk Testing

SQLSACT

SSC-Insane

Points: 21838
More actions
August 14, 2012 at 2:02 am

#262874

Hi
I'm using the SQLIO Tool to test my disks on my server
Problem is that when I choose to test multiple drives at once, I get no results. When I choose to test just one drive, I get results.
It's not that I don't get any results when I choose to test multiple drives at once, the results just report zero IO's etc...
Has anyone worked with this tool and seen this issue before?
Thanks

Viewing 10 posts - 1 through 9 (of 9 total)

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

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

can you supply details of the config file you are using

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLSACT SSC-Insane Points: 21838 More actions · Answer 2

Perry Whittle (8/14/2012)
can you supply details of the config file you are using

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

well firstly, each of the runs really needs to run for longer than 5 seconds to get any real metrics 😉

What are the results that are produced from the runs you are using in test.txt?

I'm assuming you're attempting to affinitise IO across the multiple files?

The SQLIO documentation quotes

SQLIO docs
Each line of the file specified by the -F option consists of:
<file name string> <number of threads> [<mask> [<file size (MB)] ]
Where <mask> may be in hexadecimal (preceded by 0x) or decimal and lines
beginning with # are ignored. For each line in the file, a pool of
threads will be started with the specified mask and will execute I/Os on the
specified file. The <mask> field is optional, but must be given in order to
specify the <file size> field. If <mask> is absent or 0, then no affinity
will be enforced.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLSACT SSC-Insane Points: 21838 More actions · Answer 4

Perry Whittle (8/14/2012)
well firstly, each of the runs really needs to run for longer than 5 seconds to get any real metrics 😉
What are the results that are produced from the runs you are using in test.txt?
I'm assuming you're attempting to affinitise IO across the multiple files?
The SQLIO documentation quotes
SQLIO docs
Each line of the file specified by the -F option consists of:
<file name string> <number of threads> [<mask> [<file size (MB)] ]
Where <mask> may be in hexadecimal (preceded by 0x) or decimal and lines
beginning with # are ignored. For each line in the file, a pool of
threads will be started with the specified mask and will execute I/Os on the
specified file. The <mask> field is optional, but must be given in order to
specify the <file size> field. If <mask> is absent or 0, then no affinity
will be enforced.

Attached is the results when I select one drive in the param.txt file. When I specify more that one drive in the param.txt file, it reports zero for IOps and MBps

Thanks

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

If <mask> is absent or 0, then no affinity
will be enforced.

:Whistling: 😉

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLSACT SSC-Insane Points: 21838 More actions · Answer 6

Perry Whittle (8/14/2012)
If <mask> is absent or 0, then no affinity
will be enforced.
:Whistling: 😉

Thanks

What does that mean?

Perry Whittle SSC Guru Points: 234013 More actions · Answer 7

SQLSACT (8/14/2012)
Perry Whittle (8/14/2012)
If <mask> is absent or 0, then no affinity
will be enforced.
:Whistling: 😉
Thanks
What does that mean?

OK, now i'm worried 🙂

if you intend to affinitise IO across the drives use a separate mask for each, otherwise comment out the remaining disks in the param.txt file and test them one at a time

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLSACT SSC-Insane Points: 21838 More actions · Answer 8

Perry Whittle (8/14/2012)
SQLSACT (8/14/2012)
Perry Whittle (8/14/2012)
If <mask> is absent or 0, then no affinity
will be enforced.
:Whistling: 😉
Thanks
What does that mean?
OK, now i'm worried 🙂
if you intend to affinitise IO across the drives use a separate mask for each, otherwise comment out the remaining disks in the param.txt file and test them one at a time

OK, now i'm worried 🙂

So am I !!

comment out the remaining disks in the param.txt file and test them one at a time

That's what I have been doing - I just figured it would be straight forward to get an idea from all drives at the same time

Thanks

Scott D. Jacobson SSCertifiable Points: 6149 More actions · Answer 9

I think it is straightforward from the doc.

You need something like this:

J:\testfile.dat 2 0x1 1000

K:\testfile.dat 2 0x2 1000

L:\testfile.dat 2 0x3 1000

M:\testfile.dat 2 0x4 1000