We can improve SCCM 2012 Console
performance by using of SQL server, we will have to configure a setting known
as Maximum Degree
of Parallelism or MAXDOP for short. When SQL Server runs on a
computer with more than one CPU, it detects the best degree of parallelism, the
number of processors employed to run a single statement, for each parallel plan
execution. This means that multiple queries may be executed. Setting the MAXDOP
setting to the optimal setting can help improve performance by setting the
limit to the number of physical processors.
We will use SQL to
configure this value by using SQL Management Studio using the following steps:
1) In the object
explorer, right click a server and select Properties.
2) Click the Advanced node.
3) In the Max Degree of
Parallelism box, select the maximum number of processors to use in parallel
plan execution.
The default value
of 0 uses all available processors. Set max degree of parallelism to 1 to
suppress parallel plan generation. Set the value to a number greater than 1 to
restrict the maximum number of processors used by a single parallel query
execution. If a value greater than the number of available processors is
specified, the actual number of available processors is used. If the computer
has only one processor, the max degree of parallelism value is ignored.
