Task

Get-DbaWaitingTask

Get-DbaWaitingTask View Source Shawn Melton (@wsmelton), wsmelton.github.io Windows, Linux, macOS Synopsis Retrieves detailed information about currently waiting sessions and their wait types from SQL Server dynamic management views. Description Queries sys.dm_os_waiting_tasks and related DMVs to identify sessions that are currently waiting, along with comprehensive diagnostic information including wait types, durations, blocking sessions, SQL text, and query plans. This function helps DBAs quickly identify performance bottlenecks, troubleshoot blocking issues, and analyze what’s causing slowdowns in real-time.