• I would suggest that you modify the t-sql that you are using for the metric to resemble this. It should include the object name.

    WITH CTE_1

    AS (SELECT DB_NAME() AS dbName,

    obj.name AS objectname,

    ind.name AS indexname,

    COUNT(*) AS cached_pages_count

    FROM sys.dm_os_buffer_descriptors AS bd

    INNER JOIN (SELECT object_id AS objectid,

    OBJECT_NAME(object_id) AS name,

    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 AS objectid,

    OBJECT_NAME(object_id) AS name,

    index_id,

    allocation_unit_id

    FROM sys.allocation_units AS au

    INNER JOIN sys.partitions AS p

    ON

    au.container_id = p.partition_id

    AND au.type = 2

    ) AS obj

    ON

    bd.allocation_unit_id = obj.allocation_unit_id

    LEFT OUTER JOIN sys.indexes ind

    ON

    obj.objectid = ind.object_id

    AND obj.index_id = ind.index_id

    WHERE bd.database_id = DB_ID()

    AND bd.page_type IN ('data_page', 'index_page')

    GROUP BY obj.name,

    ind.name,

    obj.index_id

    )

    SELECT TOP 1 *,

    ObjPercent = CONVERT(NUMERIC(18, 2),

    (CONVERT(NUMERIC(18, 2), cached_pages_count)

    / SUM(cached_pages_count) OVER ()) * 100)

    FROM CTE_1

    ORDER BY cached_pages_count DESC;