SQL Server 2000 dbcc indexdfrag

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Lynn Teska (lteska_at_mayo.edu)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 16:04:35 -0500

I'm trying to minimize the impact to the online users of index
defragmentation.
We have a 24/7 DB where several indexes are larger than physical memory
(4gb).
During index defragmentation high disk i/o and cpu usage make the system
slow for the users.

Is there anyway to throttle the affect of the defragmentation?
Will "option (maxdop 1)" help reduce load with this type of DBCC?

Thanks
Lynn