Memory
You can use alignment.sql script or as an alternative a stored procedure cstore_GetAlignment for getting information about the content of the Columnstore Object Pool.
@showColumnDetails bit = 1 Drills down into each of the columns inside the memory.
@showObjectTypeDetails bit = 1 Shows details about the type of the object that is located in memory.
@minMemoryInMb Decimal(8,2) = 0.0 Filters the minimum amount of memory that the Columnstore object should occupy. The default value is 0.0 MB.
@tableName nvarchar(256) = NULL
Allows to show data filtered down to 1 particular table
@columnName nvarchar(256) = NULL Allows to show data filtered down to 1 particular column name.
@objectType nvarchar(50) = NULL Allows to filter a specific type of the memory object. Possible values are 'Segment','Global Dictionary','Local Dictionary','Primary Dictionary Bulk','Deleted Bitmap'.