Home / Commands / Get-sqmBlockingReport
Get-sqmBlockingReport
Performance sqmSQLTool v1.8.2+
Retrieves current blocking chains on a SQL Server instance.

Examples

Get-sqmBlockingReport
Get-sqmBlockingReport
Get-sqmBlockingReport -SqlInstance "SQL01" -MinWaitSeconds 30
Get-sqmBlockingReport -SqlInstance "SQL01" -MinWaitSeconds 30
# Check whether blocking is currently occurring
# Check whether blocking is currently occurring
    if ((Get-sqmBlockingReport -SqlInstance "SQL01").HasBlocking) { Write-Warning "Blocking detected!" }
# Regular snapshot via Agent job
# Regular snapshot via Agent job
    Get-sqmBlockingReport -SqlInstance "SQL01" -OutputPath "$env:ProgramData\sqmSQLTool\Logs\Blocking"
← Previous Command
Test-sqmTempDbFileCount
Next Command →
Get-sqmDeadlockReport