Azure Synapse Analytics
-
Explain plan in SSMS returned as XML data type
In SSDT if you connect a query window to Azure SQL DW and put EXPLAIN in front of a query and run it you get back an XML data type column and clicking on the XML pops open a new XML window.
In SSMS when you do the same the column is a text column, not XML. As a result, most large explain plans get truncated because the length of a text column returned in SSMS is smaller than the length of an XML column.
Please change EXPLAIN plan queries to return as XML data type so that it's more…
5 votesWe 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/sql/ssms/download-sql-server-management-studio-ssms
-
Need more than 4 workload management concurrency roles
It would be good to have a few more workload management roles that would allow for greater flexibility with the bigger DWU configurations. E.g. with DWU2000 I have the choice of smallrc which is 1 concurrency slot or mediumrc which is 16. It would be nice to have a few more levels such as 2,4 and 8 in between. At the moment I am limited to 5 concurrent queries, if I need a bigger user than smallrc.
3 votesThank you for your feedback!
An additional suite of static resource classes has now been added to SQLDW.
For more information please refer to the following information:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/resource-classes-for-workload-management
-
Run queries from Web Interface
Installing SSMS or VS in order to be able to access Azure SQL DW is a heavy and cumbersome operation.
Exposing a web interface to run queries will make the product much more accessible and user friendly.
2 votesThank you for your feedback.
A T-SQL query editor is available in the portal.
-
DMV to see if autogrow is on
Apparently there is no current DMV or command to verify whether autogrow is currently on or off. Please add such a DMV.
2 votesThis information has recently become available using sys.filegroups – https://msdn.microsoft.com/en-us/library/ms187782.aspx
-
sqlcmd on Linux needs to support AD authentication
We are in the process of updating SSMS to 2016, but most of the automated, production processes we use run from Linux using SQLCMD. Our corporation dictates that all database accounts authenticate with AD (to ensure password complexity rules are enforced).
1 voteThank you for your suggestion. This request has been forwarded to the tools team for consideration in a future release.
- Don't see your idea?