Numa

Tag: numa

MAXDOP of Confusion (Dear SQL DBA Episode 8)

MAXDOP of Confusion (Dear SQL DBA Episode 8)

on July 14, 2016

Category: database-administration

Tags: automatic-soft-numa , cost-threshold-for-parallelism , dear-sql-dba , max-degree-of-parallelism , maxdop , numa , trace-flag-8079

Learn how to configure the Max Degree of Parallelism and Cost Threshold for Parallelism settings in SQL Server - and how SQL Server 2014 SP2 and SQL Server 2016 change the way that SQL Server automatically configures some SQL Servers with lots of cores.

Continue reading

Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.