How do you know if you are following best practices for Azure Synapse Analytics? One way is to check out this report that Patrick walks through. It’s a great way to get an understanding where your database is at!
Azure Synapse Analyzer Report to monitor and improve Azure Synapse SQL Dedicated Pool performance
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-analyzer-report-to-monitor-and-improve-azure/ba-p/3276960
Download Location:
https://github.com/microsoft/synapse-analyzer/tree/main/Synapse%20BPA%20Report
Maximizing rowgroup quality for columnstore indexes in dedicated SQL pool
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression