Database blocking monitoring (Advanced Suite) image

Database blocking monitoring (Advanced Suite)

作者 Neptune Tech

Provides real-time insight into blocking sessions to identify and resolve DB performance issues

  • Blocking session Identification - Instantly view sessions that are causing blocking in the SQL Server environment.

  • SPID Hierarchy analysis - View relationships between blocking and blocked sessions using SPID and Parent SPID.

  • Wait Resource tracking - See the exact resource (e.g., locks) that the session is waiting on.

  • SQL Text visibility - Analyze the SQL statement currently being executed, to diagnose blocking causes.

  • Wait time and Duration insight - Measure how long the blocking has been occurring, helping prioritize resolution.

  • Visual overview - Easy-to-read tabular format highlights blocking chains and durations.

概览

Snapshot 1 of Database blocking monitoring (Advanced Suite)