Maxdop and index rebuild on compressed indexes


  • I currently run reindexing for a compressed index, and what I have noticed is the occasional CPU spikes reaching 80 - 100%. Now I do know that compression does use CPU power quite a lot, however the server has a maxdop setting of 6 and actually has 32 cores on the box. I would like to know whether specifying maxdrop = 0 would make any difference.


    13 Maret 2012 9:44


Semua Balasan