Learn about the max degree of parallelism (MAXDOP) option. See how to use it to limit the number of processors that SQL Server uses in parallel plan execution. This option is an advanced option and ...
@MinUseCount INT = 50 -- Set minimum usecount to ignore rarely-used plans , @CurrentCostThreshold FLOAT = 5 -- Serves as minimum sub-tree cost , @MaxSubTreeCost FLOAT = 30 -- Set the maximum sub-tree ...