Home / Commands / Invoke-sqmExtendedEvents
Invoke-sqmExtendedEvents
Performance sqmSQLTool v1.8.2+
Manages Extended Events sessions for performance analysis on SQL Server.

Examples

# Create AllInOne session and start immediately
# Create AllInOne session and start immediately
    Invoke-sqmExtendedEvents -SqlInstance SQL01 -Create -Start
# Record Slow Queries > 2 seconds, save to file
# Record Slow Queries > 2 seconds, save to file
    Invoke-sqmExtendedEvents -SqlInstance SQL01 -Template SlowQueries -SlowQueryThresholdMs 2000 -TargetType File -Create -Start
# Read running session and create report
# Read running session and create report
    Invoke-sqmExtendedEvents -SqlInstance SQL01 -Read -Diagnose
# Stop session and remove it
# Stop session and remove it
    Invoke-sqmExtendedEvents -SqlInstance SQL01 -Stop -Drop
← Previous Command
Get-sqmWaitStatistics
Next Command →
Invoke-sqmPerfBaseline