drop table if exists buf_test;
select top (100000)
      identity(int, 1,1) as id
into buf_test 
from master.dbo.spt_values c1 
    cross join master.dbo.spt_values c2;

set statistics io on;

begin tran;
select * from buf_test with(repeatableread, paglock)
waitfor delay '00:00:05'
commit

select logical_reads from sys.dm_exec_requests where session_id = 79 --id первой сессии

select total_pages, data_pages, * from sys.partitions p join sys.allocation_units au on au.container_id = p.partition_id where p.object_id = object_id('buf_test')

create event session reads_stats on server 
add event physical_page_read(where session_id=79),
add event page_reference_tracker(where session_id = 79),
add event lock_acquired (where session_id = 79 and resource_type = 'PAGE'),
add event scan_stopped (where session_id = 79),
add event sql_batch_completed (where session_id = 79),
add event sql_statement_completed (where session_id = 79)
with  (max_memory = 16 MB, EVENT_RETENTION_MODE = ALLOW_MULTIPLE_EVENT_LOSS, MAX_DISPATCH_LATENCY=3 SECONDS)

select top (1000) * from [dbo].[table_with_1222640_rows] with(index=0)
select top (1000) * from [dbo].[table_with_1222640_rows] with(index=2)
select top (1000) * from [dbo].[table_with_1222640_rows] with(index=3)