Difference between sys.dm_pdw_exec_* an sys.dm_pdw_nodes_exec_*

Dance, Cody R. (ALT) 20 Reputation points

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 sys.dm_pdw_nodes_exec_*.

For the purposes of this post, let's discuss sys.dm_pdw_exec_sessions and 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?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,805 questions
{count} votes