This query runs against a SolarWinds DPA repository, retrieving a list of blocking sessions that ran in the last hour and blocked other sessions for > 5 minutes. The session's program and machine that issued the blocking query are also reported.
This query was written for a SQL Server repository. If you have a different repository DB type, modify the query syntax (mainly the "dateadd" portion) for your repository DB type.
Instructions
- Replace "_X" with the DPA database ID (run "SELECT id, name, db_type FROM cond" to find available database IDs)
- Run the query