Recently we had a company audit one of our SQL Servers (warehouse mgt system) and they did such a good job we had them do the same thing for our NAV SQL Server. We have NAV 2018 and our database size is around 500 gb. Remember every database is a little different with different hardware so take the following suggestions with a grain of salt. Also this is a list of things that might be a little less known but certainly is not all inclusive, so add things if you would like.
Starting with SQL Server 2016 (13.x), use the following guidelines when you configure the max degree of parallelism server configuration value:
Server with single NUMA node
Less than or equal to 8 logical processors
Keep MAXDOP at or below # of logical processors
Greater than 8 logical processors
Keep MAXDOP at 8
Server with multiple NUMA nodes
Less than or equal to 16 logical processors per NUMA node
Keep MAXDOP at or below # of logical processors per NUMA node
Greater than 16 logical processors per NUMA node
Keep MAXDOP at half the number of logical processors per NUMA node with a MAX value of 16
Note: NUMA node in the above table refers to soft-NUMA nodes automatically created by SQL Server 2016 (13.x) and higher versions. Use these same guidelines when you set the max degree of parallelism option for Resource Governor Workload groups.
If you've found this thread useful, dive deeper into User Group community content by role