As part of a puppet configuration for a SQL Server instance I am required at build to configure the maximum server memory to be 80% of the total physical memory max degree of parallelism to be half the number of available cores. As one of the steps in the manifest to configure the SQL Server … More Configuring SQL Server maximum server memory and max degree of parallelism using Powershell