By changing the number of processors SQL Server can use in parallel, in other words the maximum degree of parallelism (MAXDOP), we can improve index rebuild performance.
Below is an example to change it instance-wide to a value of 8 without requiring the MAXDOP hint.
In either scenario, the one method to change the MAXDOP is to insert a job step before index rebuilds to change the MAXDOP value instance-wide and another job step after the index rebuilds complete to change the value back to the original setting.
Your bio is just an ad, so you want to pique interest, and leave the meaty getting-to-know-you stuff for chats and dates. Heather, 22 I’ll have what she’s having (When Harry Met Sally quote) Derek, 25 Life moves pretty fast.… continue reading »