Dictionaries Analysis
You can use dictionaries.sql script or as an alternative a stored procedure cstore_GetDictionaries for getting detailed information about the Columnstore Dictionaries.
@showWarningsOnly bit = 0 Enables to filter out the dictionaries based on the Dictionary Size (@warningDictionarySizeInMB) and Entry Count (@warningEntryCount)
@warningDictionarySizeInMB Decimal(8,2) = 6. Defines the The size of the dictionary, after which the dictionary should be selected. The value is in Megabytes and the default value is 6 MB.
@warningEntryCount Int = 1000000 Enables filtering of dictionaries with number of entries greater than the specified one. The default value is set to 1.000.000 entries.
@showAllTextDictionaries bit = 0 Enables selecting all textual dictionaries independently from their warning status. The importance of this parameter is great, since Dictionary Pressure can kick in quite early (we have seen it starting with dictionaries starting around 6 MB) and typically these are the textual string dictionaries that are creating troubles.
@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.