In-Memory OLTP Internals - Pro SQL Server Internals - page 663

Listing 32-10. Transaction logging in in-memory OLTP: on-disk table logging
create table dbo.DiskData
(
ID int not null,
Col int not null,
constraint PK_DiskData
primary key nonclustered(ID)
)
go
declare
@I int = 1
begin tran
while @I <= 500
begin
insert into dbo.DiskData(ID, Col)
values(@I, @I)
set @I += 1
end
commit
As you can see in Figure 32-22 , the same transaction generated more than a thousand log records.
Figure 32-22. Transaction log content after on-disk table modification
You can use another undocumented function, sys.fn_dblog_xtp , to examine the logical content of an
in-memory OLTP log record. Listing 32-11 shows the code that utilizes this function and Figure 32-23 shows the
output of that code. You should use the LSN of the LSN_HK log record from the Listing 32-9 output as the parameter of
the function.