Home / Commands / Get-sqmDeadlockReport
Get-sqmDeadlockReport
Performance sqmSQLTool v1.8.2+
Reads and analyzes deadlock events from the System Health Extended Event session.

Examples

Get-sqmDeadlockReport
Get-sqmDeadlockReport
Get-sqmDeadlockReport -SqlInstance "SQL01" -StartTime (Get-Date).AddDays(-7)
Get-sqmDeadlockReport -SqlInstance "SQL01" -StartTime (Get-Date).AddDays(-7)
# Save deadlocks as XDL files for SSMS
# Save deadlocks as XDL files for SSMS
    Get-sqmDeadlockReport -SqlInstance "SQL01" -OutputPath "$env:ProgramData\sqmSQLTool\Logs\Deadlocks"
# Only deadlocks from the last hour, show number of affected statements
# Only deadlocks from the last hour, show number of affected statements
    Get-sqmDeadlockReport -StartTime (Get-Date).AddHours(-1) |
        Select-Object Timestamp, VictimLogin, VictimStatement, ProcessCount
← Previous Command
Get-sqmBlockingReport
Next Command →
Get-sqmIndexFragmentation