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

Download Location:

Maximizing rowgroup quality for columnstore indexes in dedicated SQL pool