This query shows how many pages each database has in the buffer Pool. This will show you the breakdown of memory allocation for each database.
SELECT DB_NAME(database_id), COUNT(page_id)as number_pages FROM sys.dm_os_buffer_descriptors WHERE database_id !=32767 GROUP BY database_id ORDER BY database_id
