use tempdb;
set ansi_nulls, quoted_identifier, xact_abort on;
go

create table dbo.t (id int identity primary key, s char(8000));
insert into dbo.t
 (s)
 select top (100)
  'a'
 from
  master.dbo.spt_values a cross join
  master.dbo.spt_values b;
go

drop table if exists #t;

select
 bd.*
into
 #t
from
 sys.partitions p join
 sys.allocation_units au on au.container_id = p.hobt_id join
 sys.dm_os_buffer_descriptors bd on bd.database_id = db_id() and bd.allocation_unit_id = au.allocation_unit_id
where
 p.object_id = object_id('dbo.t', 'U');
go

drop table dbo.t;

select
 au.allocation_unit_id as [sys.allocation_units allocation_unit_id], bd.*
from
 #t t join
 sys.dm_os_buffer_descriptors bd on bd.database_id = t.database_id and bd.file_id = t.file_id and bd.page_id = t.page_id left join
 sys.allocation_units au on au.allocation_unit_id = t.allocation_unit_id;
go