Home / Commands / Invoke-sqmPerfBaseline
Invoke-sqmPerfBaseline
Performance sqmSQLTool v1.8.2+
Creates, compares or lists performance baselines (wait stats + perf counters).

Examples

# Capture baseline
# Capture baseline
    Invoke-sqmPerfBaseline -SqlInstance "SQL01" -BaselineName "before_patch"
# Capture baseline after change and compare
# Capture baseline after change and compare
    Invoke-sqmPerfBaseline -SqlInstance "SQL01" -BaselineName "after_patch"
    Invoke-sqmPerfBaseline -SqlInstance "SQL01" -Action Compare
# List all baselines
# List all baselines
    Invoke-sqmPerfBaseline -SqlInstance "SQL01" -Action List
← Previous Command
Invoke-sqmExtendedEvents
Next Command →
Invoke-sqmQueryStore