How to query SQL Server Memory Manager performance counters in DMV?
The information you seek is available in the DMV sys.dm_os_performance_counters.

select object_name, 
       counter_name, 
       instance_name, 
       cntr_value, 
       cntr_type
  from sys.dm_os_performance_counters
 where 1=1
   and [object_name] = 'SQLServer:Memory Manager'