Skip to content

Issue with Columnstore index parsing #54

@RichBenner

Description

@RichBenner

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions