I have one fairly simple Insert query. Looking at the data below, I cannot undesrstand why the results show > 10,000,000 reads! (I really hope that didn't happen!!)
By gbritton 93 asked Sep 19, 2016 at 04:51 PM
It's certainly possible, especially if the table being inserted to had a large number of rows before the insert (several b-tree levels).
Logical reads are reported for non-minimally-logged inserts when SQL Server navigates down the b-tree to locate the insert point, and/or to read output values, depending on the exact scenario. Where multiple levels of b-tree are navigated per row inserted, the number may indeed exceed the number of rows. Extra reads may also be associated with prefetching activity.
The information reported by PE should be the same as given in
By SQLkiwi ♦ 6.6k answered Sep 19, 2016 at 05:39 PM