Both SQLIOSim and SQLIOStress use DeviceIOControl to determine information about the target.
On disk caches are typically not battery backed and when enabled can lead to data loss during a power outage. The utilities attempt to warn the user when on disk caching is reported as enabled.
Not all devices support interrogation of the disk cache setting. SQLIOSim logs an error condition when unable to determine the on disk cache setting instead of a warning.
01/14/08
|
09:51:10
|
4356
|
CreateFileStream
|
Error: 0x8007045D
|
CLogicalFile::GetDiskGeom
|
e:yukonsosbranchsqlntdbmsstorengutilsqliosimfileio.cpp
|
The next release of SQLIOSim won't consider this an error condition, instead a warning.
Note: As the system administrator you should validate the on disk cache settings of your system.
Bob Dorr
SQL Server Senior Escalation Engineer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.