Read Gather Streams and other parallel exchanges, inspect rows per thread and spill evidence, and relate exchange waits to actual work.
NonParallelPlanReason: Why a Query Refuses to Go Parallel
Read NonParallelPlanReason in actual and cached plans, then check MAXDOP, scalar functions, table variables, and query cost.
SQL SERVER – Audit Script to Get CPU and Memory Information with MAXDOP Guidelines
Dominic Wirth shares a new audit script to get CPU and memory information with MAXDOP guidelines for your server. Here is the script.
Running Several SQL Server Instances on One Machine
Budget several SQL Server instances on one Windows host, inventory services, assign memory and ports, and monitor shared resource pressure.
Microsoft Dynamics CRM – Max Degree of Parallelism Settings and Slow Performance
After a SQL Server upgrade, a client’s Microsoft Dynamics CRM showed slow pages and white screens. Here is how Max Degree of Parallelism settings played a part.
Cost Threshold for Parallelism and MAXDOP: Setting Both Together
Review cost threshold for parallelism with MAXDOP, inspect NUMA layout and settings, then measure plans and waits after changes.
DOP Feedback: Letting SQL Server Lower Parallelism by Itself
Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.