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

sp_BlitzIndex: columnstore compression details, include dictionary sizes #3294

Closed
BrentOzar opened this issue Jun 27, 2023 · 1 comment
Closed

Comments

@BrentOzar
Copy link
Member

Is your feature request related to a problem? Please describe.
I'm working on a course, and I want to show compression details from sys.dm_db_column_store_row_group_physical_stats.

Describe the solution you'd like
In the table-level columnstore visualization, for each rowgroup, show the state_desc, trim_reason_desc, transition_to_compressed_state_desc, and has_vertipaq_optimization columns.

Describe alternatives you've considered
Writing a separate visualization script.

Are you ready to build the code for the feature?
Yep! Coded.

@BrentOzar BrentOzar added this to the 2023-08 Release milestone Jun 27, 2023
@BrentOzar BrentOzar self-assigned this Jun 27, 2023
BrentOzar added a commit that referenced this issue Jun 27, 2023
Add columns from sys.dm_db_column_store_row_group_physical_stats. Working on #3294.
@BrentOzar BrentOzar changed the title sp_BlitzIndex: add columnstore compression details sp_BlitzIndex: columnstore compression details, include dictionary sizes Jun 30, 2023
@BrentOzar
Copy link
Member Author

Added feature while I'm in there: in the past, the columnstore visualization section didn't include the secondary dictionary sizes for each segment, only the segment size itself. Since I'm poking around in internals, it's relatively easy to include the secondary dictionary (but not the global, since it isn't repeated).

Users table, before - note the sizes in the DisplayName column at far right:
Screenshot 2023-06-30 at 9 01 15 AM

After, including the secondary dictionary sizes:
Screenshot 2023-06-30 at 9 05 30 AM

BrentOzar added a commit that referenced this issue Jun 30, 2023
In the columnstore visualization, secondary dictionary only. Working on #3294.
BrentOzar added a commit that referenced this issue Aug 15, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant