Configure MAXDOP (max degree of parallelism) on SQL Server 2016… 2019)

The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. This topic has been discussed for many years, the best practices have changed more than once (see my old post about it – https://robertostefanettinavblog.com/2015/06/04/sql-server-maxdop-configuration-option-for-microsoft-dynamics-nav/) Microsoft has now released … Read more Configure MAXDOP (max degree of parallelism) on SQL Server 2016… 2019)

SQL Server MAXDOP configuration option for Microsoft Dynamics NAV

SQL Server MAXDOP configuration option for Microsoft Dynamics NAV My question to NAV Team about suggested configuration  : ‘SET MAXDOP =  ????’  with NAV 2009, 2013, 2015 ???? http://blogs.msdn.com/b/nav/archive/2015/06/03/sql-server-worker-threads-and-microsoft-dynamics-nav.aspx Configure the max degree of parallelism Server Configuration Option https://msdn.microsoft.com/en-us/library/ms189094.aspx?f=255&MSPPError=-2147217396 sp_configure ‘show advanced options’, 1; GO RECONFIGURE WITH OVERRIDE; GO sp_configure ‘max degree of parallelism’, 1; … Read more SQL Server MAXDOP configuration option for Microsoft Dynamics NAV

%d bloggers like this: