This would be my follow-up question because I am trying to understand the CHECKDB behaviors
While running CHECKDB without any MAXDOP specified on below 2 servers:-
Server with 10 Vcores, MAXDOP at instance level 0, DB size 40 GB --> almost hitting 90% CPU spike
Server with 10 Vcores, MAXDOP at instance level 0, same like above DB in terms of schema, but data size over 150 GB --> almost hitting 30% CPU spikes
Can someone help me understand with server with same settings of instance level MAXDOP why one server will get all cores used and while other very few, probably why lower CPU usage.
Just curious how is SQL server making the conclusion of how many schedulers to allocate based on server level MAXDOP setting when running DBCC CHECKDB without specifying MAXDOP.