dm_os_process_memory

This is a view in the mssqlsystemresource database. Returns information providing a complete picture of the process memory address space in kilobytes, including things like the page_fault_count, amount of virtual address space available and committed, process physical and virtual memory, and so forth.

CREATE VIEW sys.dm_os_process_memory AS     SELECT *     FROM OpenRowSet(TABLE DM_OS_PROCESS_MEMORY)