The feature is similar to that of redshift's Distribution style all. This will reduce data transfer between distributions/nodes and consequently improve performance.204 votes
Same as Query Store in SQL Server 2016+
It would be really helpful if we can keep track of all queries executed on the server together with corresponding CPU cycles, query plan(s), logical and physical reads, etc.12 votes
We have announced a public preview of Query Store for Azure SQL Data Warehouse. You can read more about Query for SQL Data Warehouse in our blog post:
Principal Program Manager
We like to scale to DW100 during low demand.
The minimum DW for Gen2 is DW1000. This represents a 10x cost increase during these hours.
We are blocked from migrating until there is a DW100 equivalent.10 votes
Thank you for your suggestion. We now offer lower Azure SQL Data Warehouse Gen2 SKUs – all the way down to DWU100c. Please see our announcement here:
Add graphical representation of a query plan (EXPLAIN) support in SSMS/VS like we have for plans in Azure SQL/SQL Server10 votes
We are moving to SHOWPLAN as the model for exposing query details. We have recently released full SHOWPLAN_XML support with graphical execution plans in SSMS 17.5. You can see the blog announcement here:
You can download SSMS here:
Expose Clustered ColumnStore Trim reason via DMV sys.dm_db_column_store_row_group_physical_stats for debugging purposes
We're seeing in our DMVs that our Clustered ColumnStore indexes have less than 1M rows in a COMPRESSED RowGroup (200K-300K) However, there is no way to tell the TRIM_REASON for this, whether its based on memory pressure (lower resource class used when creating the CCI) or dictionary size overflows because of high cardinality of data in some columns or something else.
We need support for the DMV sys.dmdbcolumnstorerowgroupphysical_stats in SQL DW as well.2 votes
Thank you for your feedback!
This DMV is now supported in SQLDW as sys.dm_pdw_nodes_db_column_store_row_group_physical_stats
For more information please refer to the following information:
- Don't see your idea?