Is there any way to know which DMVs/DMFs are related to each other?
Some of them are well known or obvious, like sys.dm_exec_connections JOIN sys.dm_exec_sessions ON session_id = session_id, or the DMVs for missing indexes.
However, for example, I would like to know what other DMVs sys.dm_exec_sessions joins with on session_id. Session_id does not exist in sys.columns. Also, the queries here do not list anything for DMVs.
A long, long time ago Microsoft published a large .pdf poster with all of the system views for SQL Server 2005, so I'm looking for something like the for DMVs/DMFs in SQL Server 2017.