dm_os_memory_pools

This is a view in the mssqlsystemresource database. Returns a row for each memory pool object store in the SQL Server instance. Memory pool objects are certain homogeneous, equally important, stateless types of data. This information is sometimes useful for identifying bad caching behavior.

CREATE VIEW sys.dm_os_memory_pools AS     SELECT *     FROM OpenRowSet(TABLE DM_OS_MEMORY_POOLS)