Code select*from sys.dm_os_buffer_descriptors bp innerjoin ( selectOBJECT_ID,allocation_unit_id from sys.allocation_units au innerjoin sys.partitions p on au.container_id=p.hobt_id where au.type in (1,3) union selectOBJECT_ID,allocation_unit_id from sys.allocation_units au innerjoin sys.partitions p on au.container_id=p.partition_id where au.type in (2) ) as al on al.allocation_unit_id=bp.allocation_unit_id where al.OBJECT_ID=object_id('tableName') and database_id=DB_ID()