Tool to provide indexing recommendations for Synapse

Question

Hi,

is the any tools that provides indexing recommendations, as the DTA of SQL Server? Thanks

Answer 1

Hi pmscorca,

Thanks for reaching out to Microsoft Q&A.

There is no similar tool for synapse analytics dw tables but you can try the performance and indexing recommendations from your azure portal dedicated pool dashboard. Apart from that you can also try Azure Advisor, complete documentation with usage is explained below.

https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/synapse-analytics/sql-data-warehouse/sql-data-warehouse-concept-recommendations.md

Few other performance related advisor on distributions

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/distribution-advisor

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.