1 Reply Latest reply on Jun 14, 2012 1:51 PM by netlogix

    SQL Defrag

    wgibsoniii

      LI'm looking for input on how often people defrag the drives of thier SQL servers, and if you use a 3rd party or built-in defragmentation process.

        • Re: SQL Defrag
          netlogix

          I pretty much never defrag the file system (mdf/ldf files).  In order to do that, you would need to shut the database down, but I use sql commands to defrag the databases. I attached the script I use to defrag.  I create it as a SQL job, some weekly, some daily, depends on your needs.  Oh, this is just a defrag of the indexes, sometime a rebuild of them is better.