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;
/*Replace 1 with your preferred MAXDOP value */
GO
RECONFIGURE
WITH
OVERRIDE;
GO