tests/Test-SqlDbDiskAlignment.ps1
|
function Test-SqlDbDiskAlignment { [CmdletBinding()] param ( [parameter()][string] $TestName = "Validate SQL Disk Alignment", [parameter()][string] $TestGroup = "configuration", [parameter()][string] $Description = "Validate disk alignment with SQL recommended practices", [parameter()][hashtable] $ScriptParams ) try { [System.Collections.Generic.List[PSObject]]$tempdata = @() # for detailed test output to return if needed $stat = "PASS" $msg = "No issues found" <# DELETE THIS COMMENT BLOCK WHEN FINISHED: perform test and return result as an object... $stat = 'PASS' or 'FAIL' $msg = "whatever you want to provide" #> $da = Test-DbaDiskAlignment -ComputerName $ScriptParams.SqlInstance if ($da -eq $false) { $stat = "FAIL" $msg = "One or more disks are not aligned using recommended practices" } } catch { $stat = 'ERROR' $msg = $_.Exception.Message -join ';' } finally { Write-Output $([pscustomobject]@{ TestName = $TestName TestGroup = $TestGroup TestData = $tempdata Description = $Description Status = $stat Message = $msg }) } } |