Categories
Database Development

sqlserver on linux Azure performance

Im new to sqlserver, we have a sqlserver running on linux and we are encountering performance issues
i see sometimes SUSPENDED on the queries / selects etc

If i change the max degree of parallelism 0 32767 0 0
would it help?

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver15
any other comments would be great

Leave a Reply

Your email address will not be published. Required fields are marked *