• Regarding

    "The defrag that comes with win2k3 is capable of defragging the files while sql server is online, it's a huge I/O hit and the server is pratically unusable; it's possible though."

     

    Diskeeper monitors the IO queue and throttles back when this rises so the hit to the machine is near nothing.

    You could, essentially, run the defragger every hour. Why though...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!