4

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.

1

You could cheat and use Glen Berry's. The docs list the relationship cardinalities at the bottom for sys.dm_exec_requests, sys.dm_exec_connections, sys.dm_exec_cursors, sys.dm_db_session_space_usage.

Here's the map for 2012 that you're looking for. You'd just need to account for new DMVs Here is a mapping of system tables to system views. - scsimon

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.