5 Replies Latest reply on Aug 2, 2012 10:06 AM by Rob Nunes

    Should we Defrag the SQL/EPDM Server?

    Tom Cote

      I have the SolidWorks users defrag their desktop/laptops at least once a week and that has a noticable imporvement on performance.  So that leads to the question from IT; should  they should be defragging the server with EPDM and SQL on it?

       

      Thanks,

      Tom

        • Re: Should we Defrag the SQL/EPDM Server?
          Ryan McVay

          Great question and timing! I just setup a cold storage schema and have moved 320GB of data to the storage device. With all the open space I was thinking of defraggin as well!

            • Re: Should we Defrag the SQL/EPDM Server?
              Joy Garon

              Hi Tom and Ryan,

               

              Per the TS team:

               

              From the IT side, it is always good to defrag a disk. Probably won't see much improvement in SQL if SQL is set up to use Simple recovery mode and the server has enough RAM to hold all the MDF files in memory. Will most likely see better disk I/O performance for the Archive folder drive.

               

              Don’t defrag too often though as it could shorten the lifespan of the drives. Maybe once every month or every other week or so depending on usage.  We don’t think there will be too much gain on the serverside though.

               

              Hope it helps,

              Joy