SQLIOSIM Fails with UNC Path – Troubleshooting Guide

performanceperformance-testingsql serverstorage

I'm trying to run SQLIOSIM on NAS cluster's NTFS shared folder.
Here's the command line:

sqliosim.com -dir \\c16\vol1cifs -size 512 -d 600

But it repeatedly fails to create files during the setup due to following error:

Error: 0x80070057 Error Text: Description: Unable to get volume
name for mount point \\c16\vol1cifs\

vol1cifs – NTFS shared folder, that can be opened and edited on the same client where
SQLIOSIM is installed, without any problem.
According to SQLIOSIM description it does supports UNC path.

What I'm doing wrong?

Thanks for help.
Sam

Best Answer

Well, technically I'd solved the problem, although there's still question about weird sqliosim behavior.

It appears that sqliosim do creates it's files in shared NAS folder (sqliosim.mdx, sqliosim.mdx) but for some reason I can't explain, it fails to resize files and aborts.

Workaround: Create files before sqliosim run, with exactly the same size it expects, I.e: fstool file createnew \\SERVER\shared FOLDER\sqliosim.ldx [size in BYTES]

Repeat the same action for sqliosom.mdx Now run sqliosim and make yousrlf a coffee. :)

Thank you. Sam