November 7, 2005 at 11:23 am
Hi everyone,
What difference would it make if I were to change the S option of the sqliostress utility from /S3072 to /S2048? Does that mean that the test will not be as thorough? Tx.
November 8, 2005 at 4:23 am
From SQLIOStress documentation:
What file size should I use?
It is recommended that the file size be at least 2GB in size.
Why are larger memory and file sizes better?
This is a bit of a misnomer. If you are trying to use SQLIOStress to look at high level performance numbers then larger files are recommended. This is because the testing sweeps get an opportunity to run for longer and provide better data points then simple burst load results of smaller footprints provide.
On the other hand testing with smaller file sizes is also recommended because these sizes allow repetitive burst testing to take place.
A good mix of file sizes is always good.
From my own experience I can say that there's a big difference in running time. I noted these values:
256 MB - took 21 hours
4000 MB - took about 48 hours
1024 MB - took about 30 hours
Of course these are system dependent. From how I undestand purpose of sqliostress - to make sure that there are no I/O related problems in your system - I would say that the size is not so important as long as it's at least recommended value. Just my view, though.
November 8, 2005 at 10:01 am
Thanks Martin for your input. I think I will stick with 2GB size.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply