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

Figure 12-20

On most of my other systems, you can see a set of results comparable to Figure 12-21.

Running SQLIOSim on a Windows XP machine resulted in two errors. Errors are highlighted in red in
the Log viewer. You can see them both in Figure 12-22.

Take a look at the details and see what the errors are all about.

First off the User is CreateFileStream. The description of the error is ''Unable to get disk cache info for
D: '' and scrolling over to the right a bit reveals that the function is CLogicalFile::GetDiskGeom. The

results also show that the source file is fileio.cpp , and that this function lives at line 382. Unless you
have source access, this really isn't much use, but it is kind of interesting.

\

With this information, you can deduce that the error was caused because SQLIOSim had trouble reading
my disk's geometry information. As this is a local IDE disk, there's nothing to worry about.

According to blog entries for SQLIOSim, this error is in fact a known bug in SQLIOSim that will be
fixed in a future release. These entries are a great place to get started with finding out more about using
SQLIOSim. You can find these blogs by doing a web search for SQLIOSim . One of the best is the PSS SQL
Server Engineers blog.