dbatools is a free PowerShell module with over 300 SQL Server administration, best practice and migration commands included.

Please note that documentation and command names may be out of date while we work furiously towards 1.0


Test-DbaDiskSpeed

Tests how disks are performing.

This command uses a query from Rich Benner which was adapted from David Pless’s article:
MSDN
GitHub

Screenshots

dbatools-Test-DbaDiskSpeed

Examples

Tests how disks are performing on sql2008 and sqlserver2012.

Test-DbaDiskSpeed -SqlInstance sql2008, sqlserver2012

Tests how disks storing tempdb files on sql2008 are performing.

Test-DbaDiskSpeed -SqlInstance sql2008 -Database tempdb

Author

This command was created by Chrissy LeMaire. You can find Chrissy on Twitter.

Get-Help

From PowerShell, execute Get-Help Test-DbaDiskSpeed -Detailed for more information on this function.

Source Code

Want to see the source code? View Test-DbaDiskSpeed.ps1 on GitHub
 

Related commands