How Fast and Robust Is Your Storage? - Professional SQL Server 2005 Performance Tuning - page 464

ConfigurationforDSSSimulation
This is a sample INI file to simulate a DSS workload. For a DSS workload you want a lot of
ReadAhead activity and some BulkUpdate activity. If your environment is predominantly Bulk Update,
then you can set the BulkUpdateUser higher. If your workload is predominantly ReadAhead, then
set the ReadAheadUser higher (256) and set the BulkUpdateUser lower (0). This configuration differs
from the default in that UserCount for ReadAheadUser is set to 256, and UserCount for BulkUpdateUser
is set to 5. UserCount for RandomUser and AuditUser is set to 0. ShrinkUser simulation is disabled by
setting shrinkable=false on all the files to be tested.
[CONFIG]
ErrorFile=sqliosim.dss.log.xml
CPUCount=1
Affinity=0
IOAffinity=0
MaxMemoryMB=388
StopOnError=TRUE
TestCycles=12
TestCycleDuration=600
CacheHitRatio=1000
NoBuffering=TRUE
WriteThrough=TRUE
MaxOutstandingIO=0
TargetIODuration=100
AllowIOBursts=TRUE
UseScatterGather=TRUE
ForceReadAhead=TRUE
DeleteFilesAtStartup=FALSE
DeleteFilesAtShutdown=FALSE
StampFiles=FALSE
[RandomUser]
UserCount=0
JumpToNewRegionPercentage=500
MinIOChainLength=50
MaxIOChainLength=100
RandomUserReadWriteRatio=9000
MinLogPerBuffer=64
MaxLogPerBuffer=8192
RollbackChance=100
SleepAfter=5
YieldPercentage=0
CPUSimulation=FALSE
CPUCyclesMin=0
CPUCyclesMax=0
[AuditUser]
UserCount=0
BuffersValidated=64
DelayAfterCycles=2
AuditDelay=200
[ReadAheadUser]
UserCount=256
BuffersRAMin=32
BuffersRAMax=512
DelayAfterCycles=200
RADelay=200