SELECT DBName = CASE 
		WHEN database_id = 32767
			THEN 'RESOURCEDB'
		ELSE DB_NAME(database_id)
		END
	,Size_MB = COUNT(1) / 128
FROM sys.dm_os_buffer_descriptors
GROUP BY database_id
ORDER BY 2 DESC

SELECT object_name(obj.object_id) [Object]
	,isnull(si.name, 'Heap') + ' [index #' + convert(VARCHAR(10), si.index_id) + ']' AS [Index]
	,convert(NUMERIC(10, 2), count(*) / 128.) [SizeMb]
FROM sys.dm_os_buffer_descriptors AS bd
INNER JOIN (
	SELECT object_id
		,index_id
		,allocation_unit_id
	FROM sys.allocation_units AS au
	INNER JOIN sys.partitions AS p ON au.container_id = p.hobt_id
		AND (
			au.type = 1
			OR au.type = 3
			)
	
	UNION ALL
	
	SELECT object_id
		,index_id
		,allocation_unit_id
	FROM sys.allocation_units AS au
	INNER JOIN sys.partitions AS p ON au.container_id = p.hobt_id
		AND au.type = 2
	) AS obj ON bd.allocation_unit_id = obj.allocation_unit_id
LEFT JOIN sys.indexes si ON (
		si.object_id = obj.object_id
		AND si.index_id = obj.index_id
		)
WHERE bd.database_id = db_id()
GROUP BY obj.object_id
	,isnull(si.name, 'Heap') + ' [index #' + convert(VARCHAR(10), si.index_id) + ']'
ORDER BY 3 DESC,1;