Home / Commands / Test-sqmTempDbFileCount
Test-sqmTempDbFileCount
Diagnostics sqmSQLTool v1.8.2+
Prueft ob die Anzahl der TempDB-Datendateien der empfohlenen CPU-Anzahl entspricht.

Examples

Test-sqmTempDbFileCount -SqlInstance "SQL01"
Test-sqmTempDbFileCount -SqlInstance "SQL01"
Test-sqmTempDbFileCount -SqlInstance "SQL01\INST1" -MaxFiles 4
Test-sqmTempDbFileCount -SqlInstance "SQL01\INST1" -MaxFiles 4
Get-sqmAutoGrowthReport -SqlInstance "SQL01"
Get-sqmAutoGrowthReport -SqlInstance "SQL01"
Get-sqmAutoGrowthReport -SqlInstance "SQL01" -Detailed -IncludeSystem
Get-sqmAutoGrowthReport -SqlInstance "SQL01" -Detailed -IncludeSystem
← Previous Command
Test-sqmCostThreshold
Next Command →
Get-sqmBlockingReport