In this post I cover a script I’ve put together for measuring storage write speeds in SQL Server, namely against database data files.
This is meant to help get an idea of how the underlying storage performs when SQL Server is writing 1GB of data to a database.
At this point, you might be asking yourself: “Why not use CrystalDiskMark instead?”.
The answer is simple: you might not always be able to install/run additional software in an environment. Even more so if you work with external customers or you’re a consultant. It’s a lot simpler to ask a customer to run a script and send you the output, than it is to ask them to install and run some 3rd party software.
Click through for the script, what it does, and how to run it, as well as a note on limitations and example based on three drives.