Post reply

File Defragmenting

  • February 13, 2006 at 3:21 pm

    #116154

    Does anyone have any thoughts with regards to using the native Windows 2003 defragmenting application versus something like Diskeeper.
     
    A couple of our servers are sitting at > 70% fragmented which has got to be impacting lookups.
     

  • February 13, 2006 at 3:37 pm

    #620549

    Just a note. Make sure you have SQL Server is stop (or deattach the databases) or the sql files will not be defragmented.

     

    Kindest Regards,

    Amit Lohia

  • February 13, 2006 at 4:15 pm

    #620551

    From previous posts the native defragger is a cut down version of Diskeeper.

    If your files are across a RAID array or a SAN then be careful with your chosen defrag tool.

    I did some reading on this and at the time I believed that defraggers had no relevance to either of these technologies but apparently there is the physical file and there is the equivalent of a file allocation table. Defraggers designed for RAID and SAN ensure that the entries in the file allocation table are contigious and so give a performance boost that way.

    LinkedIn Profile

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply