drop table if exists [tmem], [tnonmem];
create table [tmem] (id int primary key nonclustered) with (memory_optimized=on)
create table [tnonmem] (id int primary key nonclustered)
set statistics xml on;

insert into [dbo].[tmem] 
select top(1000000) row_number() over (order by 1/0) from master.dbo.spt_values c1 
cross join master.dbo.spt_values c2 
option (maxdop 1, querytraceon 8649, querytraceon 8757);

insert into [dbo].[tmem] 
select top(1000000) 1000000+row_number() over (order by 1/0) from master.dbo.spt_values c1 
cross join master.dbo.spt_values c2 
option (maxdop 2, querytraceon 8649, querytraceon 8757);


insert into [dbo].[tnonmem] with(tablock) 
select top(1000000) row_number() over (order by 1/0) from master.dbo.spt_values c1 
cross join master.dbo.spt_values c2 
option (maxdop 1, querytraceon 8649, querytraceon 8757);

insert into [dbo].[tnonmem] with(tablock) 
select top(1000000) 1000000+row_number() over (order by 1/0) from master.dbo.spt_values c1 
cross join master.dbo.spt_values c2 
option (maxdop 2, querytraceon 8649, querytraceon 8757);

set statistics xml off;

drop table if exists [tmem], [tnonmem];