August 19, 2010 at 11:04 am
I am trying to see if my physical server can successfully run on our virtual san. To do this, I am comparing the I/O throughput from one to the other.
However, the SAN is MUCH larger controller cache (2GB) than my physical machine (256MB). So, my question is, when I set up my param.txt file, can I compare apples to apples if I go the same number of bytes OVER my controller cache for each?
Example:
ON my Virtual Server param.txt file:
F:\testfile.dat 2 0x0 2480
On my Physical Server param.txt file:
F:\testfile.dat 2 0x0 736
Also, if you have any other testing you feel would be beneficial please let me know!
Thanks a million!!
Hawkeye DBA
August 19, 2010 at 11:47 am
make sure the size of your test file is larger than the SAN cache by at least 2 x
Param file should be something like
F:\testfile.dat 2 0x0 4096
Check the Microsoft document in the SQLIO install directory for more guidance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 7:43 am
Thanks Perry!
Can you tell me, if I do that on both my SAN and my physical box to compare throughput, do I have to use the same I/O for both, or just go over the controller cache by the same amount? (see my example above)
I need to compare the two and I'm a bit hung up on this because I want to be sure that if my phsyical box shows better throughput that it's not because I've failed to stress it to the same degree I stresses my SAN.
Thanks again for your help!
Sandy
August 20, 2010 at 8:24 am
personally i would use the same file size, or maybe just one slightly smaller about 2048 MB minimum. The local controller will not have the overhead of the storage network so give it a hammering anyway!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 20, 2010 at 8:44 am
Thanks Perry, I will! BTW - I appreciate your help with this AND my other question. It's great to know there's a community of SQL Profs out there when we're all alone in our cubicle not knowing what to do next! LOL
August 20, 2010 at 9:22 am
you're welcome friend!
If you're on LinkedIn join my network and maybe recommend me if you can!
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply