Sample Header Ad - 728x90

SQL Server statistics logical reads negative number

-3 votes
1 answer
161 views
I am trying to understand and analyse a CPU intensive select query in SQL Server, however, I see something strange which is a negative number as logical reads. I wonder if it is a mathematical overflow issue or it is a meaningful number. I'm using:
-none
Microsoft SQL Server 2019 (RTM-CU29-GDR) (KB5046860) - 15.0.4410.1 (X64)
I used Statistics Parser : enter image description here Here is the raw output: ~~~lang-none Table 'T1'. Scan count 26722, logical reads -571819170, physical reads 194, page server reads 0, read-ahead reads 13211, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0. ~~~
Asked by Hossein POURAKBAR (117 rep)
Dec 23, 2024, 09:38 AM
Last activity: Dec 24, 2024, 09:16 AM