Understanding Parallelism in SQL Server

standard post
yigitaktan  -  
0 Comments  -  

When SQL Server runs on a server with more than one processor or CPU, it detects to use all available CPU’s during query execution. SQL Server’s 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 option determines the computing and thread resources that are used for the query plan operators that perform the work in parallel Read More