I make use of scripts to find missing indexes. But these scripts don't recommend missing columnstore indexes. It appears that you can have the database engine tuning advisor recommend columnstore indexes, so I'm thinking there must be a script that can make these recommendations as well?
Thanks.
maybe you can run SQL profiler during the tuning advisor and copy the script being run and customize?
Yeah. I'm going to do that if there isn't something better. The problem is that it limits the analysis to the 10 minutes (or whatever) that profiler is running. I was hoping that the views being used by scripts to determine regular missing indexes could also be leveraged for columnstore indexes.
just did a quick sql profiler and it seems to be using this proc in msdb
sp_DTA_help_session