I am trying to gather information on our use of synapse analytics and have run across two sets of dynamic management views (DMVs)- those of the form
sys.dm_pdw_exec_* and those of the form
For the purposes of this post, let's discuss
sys.dm_pdw_nodes_exec_sessions. In addition to having different information stored, these two views seem to be storing information about different sessions (or maybe different types of sessions?). This documentation provides guidance on how to link the tables (in the "Monitor tempdb" section), but this leads to totally mismatched login_name's from the two tables.
What's going on here? What is the difference between these two tables? Can they be linked?