Benchmark servers remotely with SQLIO and PowerShell

You’ve got a zoo of SQL Server instances and have to establish a baseline of IO subsystem performance?  Perhaps, you need to run IO benchmarks on a scheduled basis on IaaS servers just to see a trend over the time? Or, simply, you tasked to configure yet another SQL instance and would like to figure out what the offered hardware is capable? For all those calls the PowerShell automation is a great point to start, that can evolve infinitely. In this post I going to reveal a story of mixing Powershell, PsExec, SQLIO and Invoke-Sqlcmd together to achieve the goals.

Read More