Reindexing? Check your DOP.

re: Reindexing? Check your DOP.

Ola Hallengren — Mon, 14 Jan 2013 21:43:01 GMT

You can set the max degree of parallelism in the ALTER INDEX command, so there is no need to change the global option.

http://msdn.microsoft.com/en-us/library/ms188388.aspx

re: Reindexing? Check your DOP.

Ola Hallengren — Mon, 14 Jan 2013 21:53:05 GMT

It works also for the CREATE INDEX command.

http://msdn.microsoft.com/en-us/library/ms188783.aspx

re: Reindexing? Check your DOP.

merrillaldrich — Mon, 14 Jan 2013 23:00:36 GMT

Yes indeed. I had the scripts all prepped in this case (plus exclusive access to the server) so it was easier, but putting it in the statements would be better in general. That was me being lazy I guess :-).

Updated Warehouse Re-Index Script

Merrill Aldrich — Tue, 15 Jan 2013 00:30:00 GMT

As I talked about in my last post , I just went through a re-indexing project that took the partitioned

re: Reindexing? Check your DOP.

Digital Dog — Thu, 24 Jan 2013 13:41:24 GMT

Yes, it's the indexing that can easily max out all CPUs at 100%. If you have Standard Edition, however, that's a different story, as you noticed, because index operations are all MAXDOP 1 (even in case of usual INSERTs, UPDATEs or DELETEs).