Get-sqmLongRunningQueries - sqmSQLTool PowerShell Cmdlet Documentation

Get-sqmLongRunningQueries

Performance sqmSQLTool v1.8.2+

Identifies long-running queries on a SQL Server instance.

Examples

Get-sqmLongRunningQueries

Get-sqmLongRunningQueries

Get-sqmLongRunningQueries -SqlInstance "SQL01" -MinDurationSeconds 60

Get-sqmLongRunningQueries -SqlInstance "SQL01" -MinDurationSeconds 60

# Top 10 by duration

# Top 10 by duration
    Get-sqmLongRunningQueries -MinDurationSeconds 10 | Sort-Object DurationSeconds -Descending | Select-Object -First 10

# Regular snapshot via Agent job

# Regular snapshot via Agent job
    Get-sqmLongRunningQueries -MinDurationSeconds 120 -OutputPath "$env:ProgramData\sqmSQLTool\Logs\LongRunning"