Invoke-sqmQueryStore - sqmSQLTool PowerShell Cmdlet Documentation

Invoke-sqmQueryStore

Performance sqmSQLTool v1.8.2+

Configures the Query Store, reads from it, detects issues and saves reports.

Examples

# Report for all databases (Query + Diagnose)

# Report for all databases (Query + Diagnose)
    Invoke-sqmQueryStore -All

# Configure Query Store and query immediately

# Configure Query Store and query immediately
    Invoke-sqmQueryStore -Database "SalesDB","CRM" -Configure -Query -Diagnose

# Top 50 queries by CPU consumption, last 48 hours

# Top 50 queries by CPU consumption, last 48 hours
    Invoke-sqmQueryStore -Database "SalesDB" -Query -TopN 50 -OrderBy CPU -LookbackHours 48

# Diagnostics with storage warning from 70% and save report

# Diagnostics with storage warning from 70% and save report
    Invoke-sqmQueryStore -All -Diagnose -StorageWarningPct 70 -OutputPath "D:\Reports\QS"