search

Jorriss / StatisticsParser

Parses and formats SQL Server Statistics IO and Statistics Time output.
http://statisticsparser.com
88 stars 42 forks source link

Issue with Columnstore index parsing #54

Open RichBenner opened 2 years ago

RichBenner commented 2 years ago

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