OS Disk Defrag

  • MichaelJasson

    SSCrazy

    Points: 2732

    True SA. My straight question to everyone here. Does defrag also affect index defrag. This is not an an easy question and this depends on how defrag affects data pages. Has anyone experienced this or some errant behaviour after defrag is done?

    -MJ
    Please do not print mails and docx unless it is absolutely necessary. Spread environmental awareness.

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    5. I would also recommend shutting down SQL services - but it is not required.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    5. I would also recommend shutting down SQL services - but it is not required.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    5. I would also recommend shutting down SQL services - but it is not required.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    5. I would also recommend shutting down SQL services - but it is not required.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR

    SSC Guru

    Points: 281210

    1. Disk volumes need to be defragged.

    2. I prefer PerfectDisk (defraggler seems to work nicely too) - both are faster than Diskeeper, and all three are many times better than the Default Defragger.

    3. Disk defrag is separate from Index defrag. Idx defrags must also be done.

    4. In addition to defrag, you should verify cluster sizes and paritition alignment of your database volumes. These will also have significant impact on disk performance.

    5. I would also recommend shutting down SQL services - but it is not required.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 9 posts - 16 through 24 (of 24 total)

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