-1

Which DMV do I have to join with sys.dm_os_waiting_tasks to get the database ID?

Thom A
  • 88,727
  • 11
  • 45
  • 75
xhr489
  • 1,957
  • 13
  • 39
  • 3
    The documentation has an [example](https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-waiting-tasks-transact-sql?view=sql-server-ver15#c-view-waiting-tasks-for-all-user-processes-with-additional-information). – Thom A Oct 12 '20 at 13:03

1 Answers1

1

You can try something as follows:

SELECT TOP 100 w.session_id, e.database_id, D.name
  FROM sys.dm_os_waiting_tasks w
  LEFT JOIN sys.dm_exec_sessions e ON w.session_id = e.session_id
  LEFT JOIN sys.databases d ON e.database_id = d.database_id
Tyron78
  • 4,117
  • 2
  • 17
  • 32