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:
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.
~~~
-none
Microsoft SQL Server 2019 (RTM-CU29-GDR) (KB5046860) - 15.0.4410.1 (X64)
I used Statistics Parser :

Asked by Hossein POURAKBAR
(117 rep)
Dec 23, 2024, 09:38 AM
Last activity: Dec 24, 2024, 09:16 AM
Last activity: Dec 24, 2024, 09:16 AM