Diagnose uneven parallelism by comparing CXPACKET and CXCONSUMER with per-thread row counts in plans and live query profiles.
Setting MAXDOP and Cost Threshold Sensibly
MAXDOP and cost threshold work together to shape parallel plans; inspect current values, test a change, and watch real workload effects.
Finding Misconfigurations With One Script
Finding misconfigurations With One Script checks SQL Server settings that deserve a review, with recommendations tied to workload and evidence.
How Many CPUs SQL Server Really Uses
CPUs SQL Server really uses depend on edition, guest topology, affinity, and online schedulers; learn to see the instance’s usable capacity.
Standard Settings for a New SQL Server Install
Review standard settings for a new SQL Server install, including memory, MAXDOP, tempdb, backups, and alerts before users depend on it.