Azure Synapse Analytics

We would love to hear your ideas for new features for Azure Synapse Analytics. Below, enter a new idea or upvote an existing one. The Synapse engineering team pays attention to all requests.

If instead you need a technical question answered or help, try the these options: DocumentationMSDN forum, and StackOverflow. If you need support, please open a support ticket.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Replicated Table Support

    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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    19 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add Query Store functionality

    Same as Query Store in SQL Server 2016+
    https://msdn.microsoft.com/en-AU/library/dn817826.aspx

    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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  3. DW100 for Gen2

    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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  4. 10 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →

    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:
    https://azure.microsoft.com/en-us/blog/unlock-query-performance-with-sql-data-warehouse-using-graphical-execution-plans/

    You can download SSMS here:
    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

  5. 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
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL/Performance  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base