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

Should we Defrag the SQL/EPDM Server?

Tom Cote Jul 25, 2012 10:39 AM

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 Jul 25, 2012 10:56 AM (in response to Tom Cote)

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!
Like Show 0 Likes(0)

Actions
- Re: Should we Defrag the SQL/EPDM Server?
  
  Joy Garon Jul 25, 2012 12:30 PM (in response to Ryan McVay)
  
  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
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: Should we Defrag the SQL/EPDM Server?
    
    Tom Cote Jul 25, 2012 12:46 PM (in response to Joy Garon)
    
    Hi Joy,
    
    That is great and what was assumed but it's always good to hear it from the best!
    Actually I was asking becasue we noticed that SQL keeps taking a lot of space (and then getting slow) on theserver. But if we restart the server every few days that stays in check. So should I be optimizing the SQL database somehow?
    
    Thanks again,
    Tom
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: Should we Defrag the SQL/EPDM Server?
      
      Joy Garon Jul 25, 2012 1:05 PM (in response to Tom Cote)
      
      Hi Tom,
      
      See solution: S-042552
      
      SolidWorks recommends rebuilding the file vault database indexes at least once a month to improve overall performance. In cases of larger databases and more activity - more frequent rebuilds such as once per week may prove beneficial.
      
      The solution contains the PDF with the instructions.
      
      Regards,
      Joy
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: Should we Defrag the SQL/EPDM Server?
        
        Rob Nunes Aug 2, 2012 10:06 AM (in response to Joy Garon)
        
        Joy,
        
        Thanks for updating us with the SW rebuild recommendation.This is the first I've heard of this. I assumed WorkGroup was the only SW PDM system that required this action.
        
        Thanks again,
        Rob
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post