Maxdop query

declare @core_cnt int declare @numa_node int set @core_cnt = ( select a.[cpu_count] from [sys].[dm_os_sys_info] a ) set @numa_node = ( select max(a.[memory_node_id]) + 1   from [sys].[dm_os_memory_clerks] a   where a.[memory_node_id] < 64 ) — IF LESS THAN 5 CORES, THEN DON’T BOTHER — if @core_cnt > 4 begin declare @max_dop int — 75% OF […]