February 3, 2012 at 1:53 pm
http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO#Downloading_and_Configuring_SQLIO
Following along this SQLIO Video Tutorial and have run the batch file on all drives except the OS (Windows Server 2008 R2 Enterprise) drive. Now running on the C: drive and when I go to cmd and run "ArrayTest.bat > RESULTS-C.TXT" I get the following error:
do_ovlp_io: WriteFileEx: The parameter is incorrect.
file offset high: 0x00002b24 low: 0x5a550000
exiting
The same batch script ran fine on the other 4 disk arrays. Any idea what this error means?
February 3, 2012 at 5:22 pm
You can probably only get help if you show the SQLIO command being executed, and the contents of the param file.
Also, did you verify that the C drive has enough free space to hold the SQLIO workfile?
February 6, 2012 at 11:27 am
The C: drive has 131GB free right now, so should be good there. However, it seems to create the data file and then throws an error when it gets to about 16GB in size.
My param.txt file has:
C:\Testfile.dat 2 0x0 20480
The ArrayTest.bat file has:
sqlio -kW -t2 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o1 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o2 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o4 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o8 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o16 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o32 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o64 -frandom -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o128 -frandom -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t2 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t4 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t8 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t16 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t32 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kW -t64 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t2 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t4 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t8 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t16 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t32 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o1 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o2 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o4 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o8 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o16 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o32 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o64 -fsequential -b64 -BH -LS Testfile.dat
sqlio -kR -t64 -s120 -dC -o128 -fsequential -b64 -BH -LS Testfile.dat
The command I am running is ArrayTest.bat > RESULTS-C.TXT
February 6, 2012 at 4:55 pm
had to use a big file created by my own instead of sqlio creating it.
February 7, 2012 at 12:54 pm
Seems like a reasonable work around if your only goal is to get the SQLIO test to run, but I am more worried about the root cause of the issue. This is a new system that I will be running a production SQL Server install on. If there are issues with the hard drives, I would rather know now.
February 7, 2012 at 2:49 pm
Is SQLIO failing on the step where if first creates the workfile, or on a later step?
As another type of workaround, you could let SQLIO create the workfile on a different drive, and then copy it to the C drive.
However, you should to a complete check of the C drive to make sure ther are no problems.
Is the C drive formatted as NTFS?
February 7, 2012 at 3:07 pm
Yes, the SQLIO is failing on the step where it first creates the workfile. For some reason it is creating the work file when I run the batch script in Program Files\SQLIO. However, I run a command before that to create the work file in C:\ using the param file and it works fine. It never created this second work file in the Program Files\SQLIO folder on the previous runs of different arrays (D, L, T, etc)
I will run a chkdisk on the C: drive, is there anything else that you would specifically recommend me doing? It is formatted as NTFS.
February 7, 2012 at 3:27 pm
CHKDSK came back normal.
October 13, 2015 at 5:07 pm
I too get a similar error while running SQLio on the disk drive.
The drives are formatted in Refs and not Ntfs.
Error:
do_ovlp_io: WriteFileEx: There is not enough space on the disk.
file offset high: 0x00000599d low:0xfb3f0000
any clues?
October 13, 2015 at 7:11 pm
Mine was a bad raid controller
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply