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
Maximizing rowgroup quality for columnstore indexes in dedicated SQL pool