Memory consumption by each db

--works for 2005 and 2008
--for memory consumption by each db

select isnull(db_name(database_id),'Total memory used') as Databasename,
convert(numeric(8,2),count(page_id)/128.0) as MB
from sys.dm_os_buffer_descriptors with (nolock)
where database_id !=32767
group by database_id
with rollup
order by count(page_id) desc
got this for memory consumption by each db