Query for finding the number of pages in all databases

SELECT

DB_NAME(database_id) as DB_NAME,

COUNT(page_id)as number_pages

FROM sys.dm_os_buffer_descriptors

WHERE database_id !=32767

GROUP BY database_id

ORDER BY database_id