Databases Reference
In-Depth Information
[BulkUpdateUser]
UserCount=5
BuffersBUMin=256
BuffersBUMax=1024
DelayAfterCycles=15
BUDelay=1000
[ShrinkUser]
MinShrinkInterval=120
MaxShrinkInterval=600
MinExtends=1
MaxExtends=20
[File1]
FileName=D: \ mssql \ data \ sqliosim.mdx
InitialSize=4096
MaxSize=4096
Increment=0
Shrinkable=FALSE
LogFile=FALSE
Sparse=FALSE
[File2]
FileName=D: \ mssql \ log \ sqliosim.ldx
InitialSize=2048
MaxSize=2048
Increment=0
Shrinkable=FALSE
LogFile=TRUE
Sparse=FALSE
[File3]
FileName=
ConfigurationforDBCCSimulation
This is a sample INI file to simulate a DBCC workload. A DBCC workload is simulated by the AuditUser,
so you want to set this high, and the other user types low. This configuration differs from the default
in that UserCount for AuditUser is set to 256, and UserCount for BulkUpdateUser, RandomUser and
ReadAheadUser is set to 0. ShrinkUser simulation is disabled by setting shrinkable=false on all the
files to be tested.
[CONFIG]
ErrorFile=sqliosim.dbcc.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
Search WWH ::




Custom Search