sys.dm_db_session_space_usage
io #io#dmv
Description
Analytics Platform System (PDW) Returns the number of pages allocated and deallocated by each session for the database. In Azure SQL Database, the values are unique within a single database or an elastic pool, but Number of pages reserved or allocated for user Number of pages deallocated and no longer reserved for user objects by this session. Number of pages reserved or allocated for internal objects by this session.
Syntax
sys.dm_pdw_nodes_db_session_space_usage