MaxDop

Set-DbaMaxDop

Claudio Silva (@claudioessilva)

Set-DbaMaxDop View Source Claudio Silva (@claudioessilva) Windows, Linux, macOS Synopsis Configures SQL Server maximum degree of parallelism (MaxDOP) at instance or database level Description Configures the max degree of parallelism setting to control how many processors SQL Server uses for parallel query execution. Without a specified value, the function automatically applies recommended settings based on your server’s hardware configuration using Test-DbaMaxDop. This prevents performance issues caused by excessive parallelism on multi-core servers, especially in OLTP environments where parallel queries can create more overhead than benefit.

Test-DbaMaxDop

Claudio Silva (@claudioessilva)

Test-DbaMaxDop View Source Claudio Silva (@claudioessilva) Windows, Linux, macOS Synopsis Tests SQL Server MAXDOP configuration against recommended values based on CPU cores and NUMA topology. Description Analyzes your SQL Server’s Max Degree of Parallelism (MAXDOP) settings and compares them against Microsoft’s recommended values based on your server’s hardware configuration. This function examines CPU cores, NUMA topology, and SQL Server version to calculate optimal MAXDOP settings for query performance. The function helps you identify instances where MAXDOP may be misconfigured, which can lead to poor query performance, excessive parallelism overhead, or CXPACKET waits.