Parallel query processing is one of the best performance features available from SQL Server 2008 version onwards. By default Microsoft documentation suggests to change MAXDOP settings remain equal to number of physical processors that are being used on...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Mon, Mar 7 2011
Filed under: Filed under: sql server, performance, memory, dba, processes, worker threads, numa, statiscs age, resource governor, maxdop