FIM SQLIO Batch File

Article
07/11/2012
Applies To: Forefront Identity Manager, Forefront Identity Manager 2010
The following batch file is intended to be used with the instructions provided in Appendix A: FIM Disk Subsystem Performance Testing. To make a copy of the file, click the Copy Code link on this page and then paste the contents of your Clipboard into a file named FIMSQLIO.bat.
@ECHO OFF
:menu
set sqliopath=
set datavolumereport=
set logvolumereport=
set tempdbvolumereport=
set datavolume=
set logvolume=
set tempdbvolume=
set logfilesize=
ECHO.
ECHO ===================================================================
ECHO          SQLIO Test of Disk Subsystem for FIM 2010 WARNINGS
ECHO ===================================================================
ECHO. 
ECHO   [!] You must run this test using an account that has read and write
ECHO       permissions to the volume to be tested. You may have to run the
ECHO       test using elevated permissions (Run as administrator).
ECHO   [!] The volume to be tested should not have drive compression or
ECHO       drive indexing enabled.
ECHO   [!] The volume to be tested and SQLIO.EXE should be excluded from
ECHO       virus scanning during testing.
ECHO   [!] SQLIO.EXE should be excluded from Data Execution Prevention 
ECHO       (DEP) during testing.
ECHO   [!] There should be at least enough free disk space to create the
ECHO       test file. A fragment free or recently formatted volume is best.
ECHO   [!] Any other programs, services, or processes using the volume to 
ECHO       be tested will negatively affect the results of the test. 
ECHO   [!] These tests will negatively affect the performance of any other 
ECHO       programs, services, or processes using the volume to be tested.
ECHO.
pause
ECHO ===================================================================
ECHO            SQLIO Test of Disk Subsystem for FIM 2010
ECHO ===================================================================
ECHO.
ECHO   Press the number of the performance test would you like to run
ECHO.
ECHO       1 - test the SQL Server data volume
ECHO       2 - test the SQL Server log volume
ECHO       3 - test the SQL Server temporary database (TempDB) volume
ECHO       4 - exit to command prompt
ECHO.
ECHO   and then press ENTER
ECHO.
ECHO.   
ECHO ===================================================================
ECHO.
:choice
set /p C=Press 1, 2, 3, or 4:  
if "%C%"=="4" goto end
if "%C%"=="3" goto section3
if "%C%"=="2" goto section2
if "%C%"=="1" goto section1
goto choice

:section1
CLS
ECHO Section 1 -  Data volume testing
ECHO On Windows Server 2008 R2, the default installation path for SQLIO is
ECHO C:\Program Files (x86)\SQLIO. Type the installation path to SQLIO 
ECHO or press ENTER to use C:\Program Files (x86)\SQLIO
ECHO WARNING: DO NOT ENTER A TRAILING BACKSLASH AND  ENCLOSE PATH NAMES THAT INCLUDE SPACES WITH QUOTATION MARKS
set /p sqliopath= The SQLIO path is:  
If "%sqliopath%"=="" set sqliopath="C:\program files (x86)\SQLIO"
ECHO.
ECHO Type the path to the folder in which you want to store these test reports or
ECHO press ENTER to store report files in C:\Program Files (x86)\SQLIO
ECHO WARNING: DO NOT ENTER A TRAILING BACKSLASH AND  ENCLOSE PATH NAMES THAT INCLUDE SPACES WITH QUOTATION MARKS
set /p datavolumereport= The folder to store the data volume report is:   
If "%datavolumereport%"=="" set datavolumereport="C:\program files (x86)\SQLIO"
ECHO.
ECHO Type the volume letter of the volume you want to test.
ECHO after the volume letter and then press ENTER. 
ECHO Or press ENTER to accept default of C.
ECHO WARNING: DO NOT ENTER A TRAILING COLON (:) or BACKSLASH
set /p datavolume= Volume letter (only):  
If "%datavolume%"=="" set datavolume=C
ECHO.
ECHO Type the data file size in MB that you want to test on the target volume and press ENTER.
ECHO Or press ENTER to accept default of 5 GB (5120 MB).
ECHO WARNING: ENTER THE NUMBER ONLY; DO NOT ADD MB to the end.
set /p datafilesize= Number of MB (number only):  
If "%datafilesize%"=="" set datafilesize=5120
CLS

ECHO ===================================================================
ECHO %datavolume%: data volume testing started at %time% on %date%.
ECHO ===================================================================
ECHO.
ECHO SQLIO is located at %sqliopath%
ECHO.
ECHO Reports will be sent to %datavolumereport%
ECHO.
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %datavolume%: data volume write testing started at %time% on %date% >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 5 k Writes 1 thread to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 1 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o1 -frandom -b5 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o1 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o4 -frandom -b5 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o4 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o16 -frandom -b5 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o16 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o32 -frandom -b5 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o32 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 5 k Writes 1 thread to %datavolume%: data volume completed

timeout /T 5

ECHO random 5 k Writes 4 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 4 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o1 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o1 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o4 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o4 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o16 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o16 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o32 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o32 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 5 k Writes 4 threads to %datavolume%: data volume completed

timeout /T 5

ECHO random 5 k Writes 16 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 16 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o1 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o1 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o4 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o4 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o16 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o16 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o32 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o32 -frandom -b5 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 5 k Writes 16 threads to %datavolume%: data volume completed

timeout /T 5

ECHO random 10 k Writes 1 thread to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 1 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o1 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o1 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o4 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o4 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o16 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o16 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o32 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o32 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 10 k Writes 1 thread to %datavolume%: data volume completed

timeout /T 5

ECHO random 10 k Writes 4 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 4 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o1 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o1 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o4 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o4 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o16 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o16 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o32 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o32 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 10 k Writes 4 threads to %datavolume%: data volume completed

timeout /T 5

ECHO random 10 k Writes 16 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 16 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o1 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o1 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o4 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o4 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o16 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o16 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o32 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o32 -frandom -b10 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 10 k Writes 16 threads to %datavolume%: data volume completed
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %datavolume%: data volume write testing completed at %time% on %date% >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt 
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %datavolume%: data volume write testing complete; read testing started at %time% on %date%
ECHO. >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO.
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %datavolume%: data volume read testing started at %time% on %date% >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt 
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt

ECHO random 16 k reads 1 thread to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 1 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o4 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o4 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o16 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o16 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o32 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o32 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 16 k reads 1 thread to %datavolume%: data volume completed

timeout /T 5

ECHO random 16 k reads 4 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 4 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o1 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o1 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o4 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o4 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o16 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o16 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o32 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o32 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 16 k reads 4 threads to %datavolume%: data volume completed

timeout /T 5

ECHO random 16 k reads 16 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 16 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o1 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o1 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o4 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o4 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o16 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o16 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o32 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o32 -frandom -b16 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 16 k reads 16 threads to %datavolume%: data volume completed
timeout /T 5

ECHO random 32 k reads 1 thread to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 1 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b32 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o4 -frandom -b32 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o4 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o16 -frandom -b32 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o16 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o32 -frandom -b32 -BH -LS %datavolume%:\TestFile1.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o32 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 32 k reads 1 thread to %datavolume%: data volume completed

timeout /T 5

ECHO random 32 k reads 4 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 4 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o1 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o1 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o4 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o4 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o16 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o16 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o32 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o32 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 32 k reads 4 threads to %datavolume%: data volume completed

timeout /T 5

ECHO random 32 k reads 16 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 16 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o1 -frandom -b32 -BH -LS %datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o1 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o4 -frandom -b32 -BH -LS %datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o4 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o16 -frandom -b32 -BH -LS %datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o16 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o32 -frandom -b32 -BH -LS %datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o32 -frandom -b32 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 32 k reads 16 threads to %datavolume%: data volume completed

timeout /T 5

ECHO random 64 k reads 1 thread to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 1 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o4 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o4 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o16 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o16 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o32 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o32 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 64 k reads 1 thread to %datavolume%: data volume completed

timeout /T 5

ECHO random 64 k reads 4 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 4 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o1 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o1 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o4 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o4 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o16 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o16 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t4 -o32 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t4 -o32 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 64 k reads 4 threads to %datavolume%: data volume completed

timeout /T 5

ECHO random 64 k reads 16 threads to %datavolume%: data volume running
ECHO %datavolume%:\datafile.dat 16 0x00 %datafilesize% > %datavolumereport%\datafileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o1 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o1 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o4 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o4 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o16 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o16 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t16 -o32 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
%sqliopath%\sqlio -kR -s300 -t16 -o32 -frandom -b64 -BH -LS -d%datavolume% -F%datavolumereport%\datafileparam.txt datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO random 64 k reads 16 threads to %datavolume%: data volume completed
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO %datavolume%: read testing completed at %time% on %date% >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt 
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
ECHO ===================================================================
ECHO %datavolume%: testing completed at %time% on %date%
ECHO ===================================================================
ECHO.
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
dir %datavolume%:\datafile.dat >> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt 
ECHO ===================================================================>> %datavolumereport%\FIMSQLIO-Report-DataVolume.txt
del %datavolume%:\datafile.dat
del %datavolumereport%\datafileparam.txt 
pause
CLS
goto menu

:section2
CLS
ECHO Section 2 - Log Volume Testing
ECHO On Windows Server 2008 R2, the default installation path for SQLIO is
ECHO C:\Program Files (x86)\SQLIO. Type the installation path to SQLIO 
ECHO or press ENTER to use C:\Program Files (x86)\SQLIO
ECHO WARNING: DO NOT ENTER A TRAILING BACKSLASH AND  ENCLOSE PATH NAMES THAT INCLUDE SPACES WITH QUOTATION MARKS
set /p sqliopath= The SQLIO path is:  
If "%sqliopath%"=="" set sqliopath="C:\program files (x86)\SQLIO"
ECHO.
ECHO Type the path to the folder in which you want to store these test reports or
ECHO press ENTER to store report files in C:\Program Files (x86)\SQLIO
ECHO WARNING: DO NOT ENTER A TRAILING BACKSLASH AND  ENCLOSE PATH NAMES THAT INCLUDE SPACES WITH QUOTATION MARKS
set /p logvolumereport= The folder to store the Log file report is:   
If "%logvolumereport%"=="" set logvolumereport="C:\program files (x86)\SQLIO"
ECHO.
ECHO Type the volume letter of the volume you want to test.
ECHO after the volume letter and then press ENTER. 
ECHO Or press ENTER to accept default of C.
ECHO WARNING: DO NOT ENTER A COLON (:) TRAILING BACKSLASH
set /p logvolume= Volume letter (only):  
If "%logvolume%"=="" set logvolume=C
ECHO.
ECHO Type the log file size in MB that you want to test on the target volume and press ENTER.
ECHO Or press ENTER to accept default of 5 GB (5120 MB).
ECHO WARNING: ENTER THE NUMBER ONLY; DO NOT ADD MB to the end.
set /p logfilesize= Number of MB (number only):  
If "%logfilesize%"=="" set logfilesize=5120
CLS

ECHO.
ECHO ===================================================================
ECHO %logvolume%: log volume testing started at %time% on %date%.
ECHO ===================================================================
ECHO.
ECHO SQLIO is located at %sqliopath%
ECHO.
ECHO Reports will be sent to %logvolumereport%
ECHO.
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %logvolume%: log volume write testing started at %time% on %date% >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt

ECHO Sequential 5 k Writes 1 thread to %logvolume%: log volume running
ECHO %logvolume%:\logfile.dat 1 0x00 %logfilesize% > %logvolumereport%\logfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o1  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o1  -b5 -BH -LS -fsequential -d%logvolume%  -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o4 -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o4  -b5 -BH -LS -fsequential -d%logvolume%  -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o16  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o16  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o32  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o32  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 5 k Writes 1 thread to %logvolume%: log volume completed

timeout /T 5

ECHO Sequential 5 k Writes 4 threads to %logvolume%: log volume running
ECHO %logvolume%:\logfile.dat 4 0x00 %logfilesize% > %logvolumereport%\logfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o1  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o1  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o4 -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o4  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o16  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o16  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o32  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o32  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 5 k Writes 4 threads to %logvolume%: log volume completed

timeout /T 5

ECHO Sequential 5 k Writes 16 threads to %logvolume%: log volume running
ECHO %logvolume%:\logfile.dat 16 0x00 %logfilesize% > %logvolumereport%\logfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o1  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o1  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o4 -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o4  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o16 -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o16  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o32  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o32  -b5 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 5 k Writes 16 threads to %logvolume%: log volume completed

timeout /T 5

ECHO Sequential 10 k Writes 1 thread to %logvolume%: log volume running
ECHO %logvolume%:\logfile.dat 1 0x00 %logfilesize% > %logvolumereport%\logfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o1 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o1  -b10 -BH -LS -fsequential -d%logvolume%  -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o4 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o4  -b10 -BH -LS -fsequential -d%logvolume%  -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o16 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o16  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o32  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o32  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 10 k Writes 1 thread to %logvolume%: log volume completed

timeout /T 5

ECHO Sequential 10 k Writes 4 threads to %logvolume%: log volume running
ECHO %logvolume%:\logfile.dat 4 0x00 %logfilesize% > %logvolumereport%\logfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o1 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o1  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o4 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o4  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o16 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o16  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o32  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o32  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt  logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 10 k Writes 4 threads to %logvolume%: log volume completed

timeout /T 5

ECHO Sequential 10 k Writes 16 threads to %logvolume%: log volume running
ECHO %logvolume%:\logfile.dat 16 0x00 %logfilesize% > %logvolumereport%\logfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o1 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o1  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o4 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o4  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o16 -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o16  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o32  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o32  -b10 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 10 k Writes 16 threads to %logvolume%: log volume completed
ECHO.
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %logvolume%: log volume write testing complete at %time% on %date% >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt 
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO. >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %logvolume% write testing complete; read testing started at %time% on %date%
ECHO.
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %logvolume%: log volume read testing started at %time% on %date% >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 60 k reads 1 thread to %logvolume%: log volume running
ECHO %logvolume%:\logfile.dat 1 0x00 %logfilesize% > %logvolumereport%\logfileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o1,4,16,32  -b60 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o1 -b60 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o4  -b60 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o16  -b60 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o32  -b60 -BH -LS -fsequential -d%logvolume% -F%logvolumereport%\logfileparam.txt logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO Sequential 60 k reads 1 thread to %logvolume%: log volume completed
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO %logvolume%: log volume read testing completed at %time% on %date% >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
ECHO ===================================================================
ECHO %logvolume%: log volume testing complete at %time% on %date%.
ECHO ===================================================================
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
dir %logvolume%:\logfile.dat >> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt 
ECHO ===================================================================>> %logvolumereport%\FIMSQLIO-Report-LogVolume.txt
del %logvolume%:\logfile.dat 
del %logvolumereport%\logfileparam.txt
pause
CLS
goto menu


:section3
CLS
ECHO Section 3 - Temporary Database (TempDB) volume tests
ECHO On Windows Server 2008 R2, the default installation path for SQLIO is
ECHO C:\Program Files (x86)\SQLIO. Type the installation path to SQLIO 
ECHO or press ENTER to use C:\Program Files (x86)\SQLIO
ECHO WARNING: DO NOT ENTER A TRAILING BACKSLASH AND ENCLOSE PATH NAMES THAT INCLUDE SPACES WITH QUOTATION MARKS
set /p sqliopath= The SQLIO path is:  
If "%sqliopath%"=="" set sqliopath="C:\program files (x86)\SQLIO"
ECHO.
ECHO Type the path to the folder in which you want to send the TempDB test reports or
ECHO press ENTER to store report files in C:\Program Files (x86)\SQLIO
ECHO WARNING: DO NOT ENTER A TRAILING BACKSLASH AND  ENCLOSE PATH NAMES THAT INCLUDE SPACES WITH QUOTATION MARKS
set /p tempdbvolumereport= The folder to store the TempDB report is:   
If "%tempdbvolumereport%"=="" set tempdbvolumereport="C:\program files (x86)\SQLIO"
ECHO.
ECHO Type the volume letter of the volume you want to test.
ECHO after the volume letter and then press ENTER. 
ECHO Or press ENTER to accept default of C.
ECHO WARNING: DO NOT ENTER A COLON (:) TRAILING BACKSLASH
set /p tempdbvolume= Volume letter (only):  
If "%tempdbvolume%"=="" set tempdbvolume=C
ECHO.
ECHO Type the tempdb file size in MB that you want to test on the target volume and press ENTER.
ECHO Or press ENTER to accept default 5 GB (5120 MB).
ECHO WARNING: ENTER THE NUMBER ONLY; DO NOT ADD MB to the end.
set /p tempdbfilesize= Number of MB (number only):  
If "%tempdbfilesize%"=="" set tempdbfilesize=5120
CLS

ECHO.
ECHO ===================================================================
ECHO %tempdbvolume%: TempDB volume testing started at %time% on %date%.
ECHO ===================================================================
ECHO.
ECHO SQLIO is located at %sqliopath%
ECHO.
ECHO Reports will be sent to %tempdbvolumereport%
ECHO.
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %tempdbvolume%: TempDB volume write testing started at %time% on %date% >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt

ECHO random 60 k Writes 1 thread to %tempdbvolume%: TempDB volume running
ECHO %tempdbvolume%:\tempdbfile.dat 1 0x00 %tempdbfilesize% > %tempdbvolumereport%\tempdbfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t1 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t1 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO random 60 k Writes 1 thread to %tempdbvolume%: TempDB volume completed

timeout /T 5

ECHO random 60 k Writes 4 threads to %tempdbvolume%: TempDB volume running
ECHO %tempdbvolume%:\tempdbfile.dat 4 0x00 %tempdbfilesize% > %tempdbvolumereport%\tempdbfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t4 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t4 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO random 60 k Writes 4 threads to %tempdbvolume%: TempDB volume completed

timeout /T 5

ECHO random 60 k Writes 16 threads to %tempdbvolume%: TempDB volume running
ECHO %tempdbvolume%:\tempdbfile.dat 16 0x00 %tempdbfilesize% > %tempdbvolumereport%\tempdbfileparam.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kW -s300 -t16 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kW -s300 -t16 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO random 60 k Writes 16 threads to %tempdbvolume%: TempDB volume completed
ECHO.
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %tempdbvolume%: TempDB volume write testing completed at %time% on %date% >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt 
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO. >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %tempdbvolume% write testing complete; read testing started at %time% on %date%
ECHO.
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %tempdbvolume%: TempDB volume read testing started at %time% on %date% >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO random 60 k reads 1 thread to %tempdbvolume%: TempDB volume running
ECHO %tempdbvolume%:\tempdbfile.dat 1 0x00 %tempdbfilesize% > %tempdbvolumereport%\tempdbfileparam.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt  >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio -kR -s300 -t1 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t1 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t1 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio -kR -s300 -t1 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t1 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO random 60 k reads 1 thread to %tempdbvolume%: TempDB volume completed

timeout /T 5

ECHO random 60 k reads 4 threads to %tempdbvolume%: TempDB volume running
ECHO %tempdbvolume%:\tempdbfile.dat 4 0x00 %tempdbfilesize% > %tempdbvolumereport%\tempdbfileparam.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t4 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t4 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t4 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t4 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t4 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t4 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t4 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t4 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO random 60 k reads 1 thread to %tempdbvolume%: TempDB volume completed

timeout /T 5

ECHO random 60 k reads 16 threads to %tempdbvolume%: TempDB volume running
ECHO %tempdbvolume%:\tempdbfile.dat 16 0x00 %tempdbfilesize% > %tempdbvolumereport%\tempdbfileparam.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t16 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t16 -o1 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t16 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t16 -o4 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t16 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t16 -o16 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %sqliopath%\sqlio  -kR -s300 -t16 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
%sqliopath%\sqlio  -kR -s300 -t16 -o32 -frandom -b60 -BH -LS -d%tempdbvolume% -F%tempdbvolumereport%\tempdbfileparam.txt tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO random 60 k reads 1 thread to %tempdbvolume%: TempDB volume completed

ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO %tempdbvolume%: TempDB volume read testing completed at %time% on %date% >> FIMSQLIO-Report-TempDBVolume.txt >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
ECHO ===================================================================
ECHO %tempdbvolume%: TempDB volume testing completed at %time% on %date%.
ECHO ===================================================================
ECHO.
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
dir %tempdbvolume%:\tempdbfile.dat >> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt 
ECHO ===================================================================>> %tempdbvolumereport%\FIMSQLIO-Report-TempDBVolume.txt
del %TempDBvolume%:\tempdbfile.dat
del %tempdbvolumereport%\tempdbfileparam.txt
pause
CLS
goto menu
:end
::EOF
FIM SQLIO Batch File

See Also

Concepts

Additional resources
