Configure degree of parallelism

/* VALUES MAX DEGREE OF PARALLELISM
0 (Default) <All processors>
1           <Parallelism is deactive>
>= 2        <Parallelism is active (Numbers of processors)>
*/
--show advanced options
EXEC sys.sp_configure N'show advanced options', N'1'  
RECONFIGURE WITH OVERRIDE
GO
--Set value 2
EXEC sys.sp_configure N'max degree of parallelism', N'2'
GO
RECONFIGURE WITH OVERRIDE
GO
--disable advanced options
EXEC sys.sp_configure N'show advanced options', N'0'  
RECONFIGURE WITH OVERRIDE
GO

This site uses Akismet to reduce spam. Learn how your comment data is processed.