Databases Reference
In-Depth Information
FIGURE 4-13
SQLIO is a tool that simply generates I/O. This application is executed from the command line and
does not need SQL Server to run. Download SQLIO from
http://www.microsoft.com/download/
We recommend testing the storage system to performance maximums and setting up a test that
mimics your best guess at a production workload. SQLIO is executed from the Windows com-
mand line. After installing SQLIO, open the
param.txt
i le located in the installation directory.
The default path is C:\Program Files (x86)\SQLIO. The
param.txt
i le contains the
following code:
c:\testfile.dat 2 0x0 100
#d:\testfile.dat 2 0x0 100
The i rst line in the param i le dei nes where the test i le is located. Use the pound sign (#) to com-
ment out a line in the
param.txt
i le. The i rst number following the test i le dei nes the number of
threads per test i le. Microsoft recommends setting this to the number of CPU cores running on the
host machine. Leave the mask set at 0x0. Finally, the size of the test i le in MB is dei ned.
Ensure that the test i le is large enough to exceed the amount of cache dedicated to your storage vol-
umes. If the host i le is too small it will eventually be stored within the array cache.
SQLIO is designed to run a specii c workload per instance. Each time you execute
SQLIO.exe
with
parameters, it will dei ne a specii c type of I/O. It is entirely permissible to run many instances of
SQLIO in parallel against the same test i le.
Search WWH ::
Custom Search