data-konzept

'Last week I’ve been testing some new storage at work to see how it performs and I got to use a [hopefully] well known tool provided by Microsoft called diskspd.exe

Diskspd.exe is great to generate read write activity in a volume (regardless it’s a local disk or coming from a SAN like my case) using different parameters to hammer it in a variety of ways, trying to replicate the multiple ways SQL Server performs IO operations.

** Disclaimer: SAN storage is more complex to test due to the more sophisticated way to serve the data which might include caching and automated tiering. Please check this podcast for more details

In this post I am not going to get into many details about the tool itself, but in how to process the generated output for baselining or benchmarking our storage subsytem.'...

http://www.sqldoubleg.com/2017/03/02/benchmarking-storage-using-diskspd-exe/