How are logical reads calculated?

I read the definition of logical readings:

http://msdn.microsoft.com/en-us/library/ms184361.aspx

He says:

"The number of pages read from the data cache."

I have two tables (the number of rows of table_1 is 141 , and table_2 is 16.811 ), when I run these two queries, it gives the following result.

SELECT * FROM Table_1

results
Scan count 1, logical reads 6, physical reads 0, read-ahead reads 0.

SELECT * FROM Table_2

results
scan count 1, logical reads 701, physical reads 0, read-ahead reads 0

if the logic reading is "The number of pages read from the data cache." What is a page? How is it calculated?

+3
source share
2 answers

A page is the smallest physical data block that SQL Serverworks with.

8K long , .

10 , .

20 .

+2

, .

? SELECT, 10 . 8 , , 80 , ?

0

Source: https://habr.com/ru/post/1729055/


All Articles