You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm doing some testing against the Stack Overflow database with Columnstore indexes and the parsing isn't working properly. My statistics are at the bottom of this bug for reproduction purposes.
The columns displayed by the tool are;
Scan Count
Logical Reads
Physical Reads
Read-Ahead Reads
LOB Logical Reads
LOB Physical Reads
LOB Read-Ahead Reads
The columns that my statistics have are here;
Scan Count (32)
Logical Reads (0)
Physical Reads (0)
Page Ahead Reads (0)
Read-Ahead Reads (0)
Page Server Read-Ahead Reads (0)
LOB Logical Reads (1448751)
LOB Physical Reads (9)
LOB Page Server Reads (0)
LOB Read-Ahead Reads (1355388)
LOB Page Server Read-Ahead Reads (0)
When being displayed, it's only showing the "Scan Count: 32" field, everything else is zero (and the "% Logical Reads of Total Reads" returns NaN).
I don't have the skills to push a fix for this myself but if anybody else has time to fix or to point out what I'm doing wrong it would be greatly appreciated.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 8 ms.
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
I'm doing some testing against the Stack Overflow database with Columnstore indexes and the parsing isn't working properly. My statistics are at the bottom of this bug for reproduction purposes.
The columns displayed by the tool are;
The columns that my statistics have are here;
When being displayed, it's only showing the "Scan Count: 32" field, everything else is zero (and the "% Logical Reads of Total Reads" returns NaN).
I don't have the skills to push a fix for this myself but if anybody else has time to fix or to point out what I'm doing wrong it would be greatly appreciated.
The text was updated successfully, but these errors were encountered: