Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue with Columnstore index parsing #54

Open
RichBenner opened this issue Oct 11, 2021 · 0 comments
Open

Issue with Columnstore index parsing #54

RichBenner opened this issue Oct 11, 2021 · 0 comments

Comments

@RichBenner
Copy link

RichBenner commented Oct 11, 2021

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;

  1. Scan Count
  2. Logical Reads
  3. Physical Reads
  4. Read-Ahead Reads
  5. LOB Logical Reads
  6. LOB Physical Reads
  7. LOB Read-Ahead Reads

The columns that my statistics have are here;

  1. Scan Count (32)
  2. Logical Reads (0)
  3. Physical Reads (0)
  4. Page Ahead Reads (0)
  5. Read-Ahead Reads (0)
  6. Page Server Read-Ahead Reads (0)
  7. LOB Logical Reads (1448751)
  8. LOB Physical Reads (9)
  9. LOB Page Server Reads (0)
  10. LOB Read-Ahead Reads (1355388)
  11. 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.

(528996 rows affected)
Table 'Comments'. Scan count 32, logical reads 0, physical reads 0, page server 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.
Table 'Comments'. Segment reads 404, segment skipped 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, 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.

(1 row affected)

SQL Server Execution Times:
CPU time = 254189 ms, elapsed time = 35970 ms.
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.

Completion time: 2021-10-11T16:26:16.4485011+01:00

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant